unique
unique(list
)
The UNIQUE function has the following arguments:
list
A 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} |