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 that appear to be duplicates, ensure that cells including text do not have differing hidden text, such as trailing spaces.

  • Ensure that numerical 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.

Make a copy

Was this helpful?
How can we improve it?