Returns a list of unique values in the provided range.

Sample Usage



UNIQUE(range, [by_column], [exactly_once])

  • range  - The range of cells to be examined. 
  • by_column  - [OPTIONAL] Whether to filter the data by columns or by rows. By default, this is false
  • range  - [OPTIONAL] Whether to return only entries with no duplicates. By default, this is false


UNIQUE(C5:C15) returns all the unique values in the range C5:C15.


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