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 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.
Examples
| Colour 1 | Colour 2 | Colour 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 | |