Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The UNIQUE function removed duplicate items from a list.
Syntax
UNIQUE(value1, value2, [value3], ...)
The UNIQUE function syntax has the following arguments:
- value1 Required. A text value
- value2 Required. A text value
- value3 Optional. A text value
Example
| Formula | Description | Result |
| =UNIQUE("a", "c", "a", "b", "c", "b") | Removed duplicate values from the list a, c, a, b, c, b. | a, c, b |
| =UNIQUE(9, 7, 4, 7, 9) | Removed duplicate values from the list 9, 7, 4, 7, 9. | 9, 7, 4 |
Errors
For a full list of formula errors, please read Formula errors.