Name

unique — Remove duplicate items from a list

Syntax

unique(list)
              

The UNIQUE function has the following arguments:

list

A list that will have duplicate entries removed.

Description

Duplicated entries will be removed from the list. The ordering of the remaining values is the list is unchanged.

Examples

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}