Unique function

Eliminates all duplicate values in lists or tables


Description

The function Unique generates from a list or table a new list in which all duplicate values are eliminated.

In the case of tables, the number of the column to be searched is also specified.

The option asc arranges the result as ascending, dsc as a descending list.


Syntax

Unique (list)

Checks the values of the list.

Unique (table)

Checks the values of the first column of a table.

Unique (table, column)

Checks the values of the given column of a table.

Example

Unique([2,8,5,2,9,4,5])=2 8 5 9 4

Unique([2,8,5,2,9,4,5],"asc")=2 4 5 8 9

Unique([2,8,5,2,9,4,5],"dsc")=9 8 5 4 3