UNIQUE

Returns a list of unique values in the provided range.

Sample Usage

UNIQUE(C5:C15)

Syntax

UNIQUE(range)

  • range  - The range of cells to be examined. 

 

Examples

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

 

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.