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:
FILTER: Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
Examples
Displays the unique rows specified in a range.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.