Clear search
Close search
Google apps
Main menu


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({1, 2; 3, 4; 5, 6})



  • range - The data to filter by unique entries.


  • 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.


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.

Was this article helpful?
How can we improve it?