unique
unique(list)
The UNIQUE function has the following arguments:
listA list that will have duplicate entries removed.
Duplicated entries will be removed from the list. The ordering of the remaining values is the list is unchanged.
|
Formula |
Description |
Result |
|---|---|---|
| unique({'a','c','a','b','a','b','c'}) | Remove duplicates | {'a','c','b'} |
| unique({1,2,3,1,2,3}) | Remove duplicates | {1,2,3} |