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.
Parts of a UNIQUE function
UNIQUE(range, by_column, exactly_once)
| Part | Description |
|---|---|
| range |
The data to filter by unique entries. |
| by_column |
Whether to filter the data by columns or by rows. By default, this is false. |
| exactly_once |
Whether to return only entries with no duplicates. By default, this is false. |
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.
Examples
Color 1
Color 2
Color 3
Red
Yellow
Red
Blue
Magenta
Blue
Red
Yellow
Red
Green
White
Green
Formula
=UNIQUE(B2:D5)
Output
Red
Yellow
Red
Blue
Magenta
Blue
Green
White
Green
Formula
=UNIQUE(B2:D5, TRUE)
Output
Red
Yellow
Blue
Magenta
Red
Yellow
Green
White
Formula
=UNIQUE(B2:D5, TRUE)
Output
Blue
Magenta
Blue
Green
White
Green
