INFO
This page was originally generated from official documentation.
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.
Syntax
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 |