Syntax

This name carries two entries in Google’s list, one under each type below. Both syntaxes and both records are shown, each one attributed.

UNIQUE — Filter, as Google Docs Editors Help, “Google Sheets function list” lists it

UNIQUE(range)

UNIQUE — Operator, as Google Docs Editors Help, “Google Sheets function list” lists it

UNIQUE(range, by_column, exactly_once)

Arguments

UNIQUE — Filter: record 77 of 516

The printed syntax lists 1 argument(s), in order:

  • range

UNIQUE — Operator: record 282 of 516

The printed syntax lists 3 argument(s), in order:

  • range
  • by_column
  • exactly_once

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

UNIQUE — Filter: record 77 of 516

“Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.”

UNIQUE — Operator: record 282 of 516

“Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.”

Google’s help article for UNIQUE (Filter record) →

Google’s help article for UNIQUE (Operator record) →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 77 of 516, data fetched 28 September 2026. Data month: September 2026.

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 282 of 516, data fetched 28 September 2026. Data month: September 2026.

Google’s list also carries this name as record 282 of 516 (Operator); both records name the same help article, https://support.google.com/docs/answer/10522653.