UNIQUE

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.

Sample Usage

UNIQUE(A2:B26)

UNIQUE({1, 2; 3, 4; 5, 6})

Syntax

UNIQUE(range)

  • range - The data to filter by unique entries.

Notes

  • If rows are returned which appear to be duplicates, ensure that cells including text do not have differing hidden text such as trailing spaces.

  • Ensure that numeric values are formatted in the same way - percentages as percentages, currency values as currency values, etc.

See Also

SORT: Sorts the rows of a given array or range by the values in one or more columns.

FILTER: Returns a filtered version of the source range, returning only rows or columns that meet the specified conditions.

Examples

Displays the unique rows specified in a range.

Make a copy

Was this article helpful?
How can we improve it?