Returns a list of unique values in the provided range.
Sample Usage
UNIQUE(C5:C15)
Syntax
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.
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.