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.