Examples

UNIQUE(LIST(1, 1, 2, 1, 3)) : 1, 2, 3

UNIQUE(LIST("Mary", "David", "Joe", "David")) : Mary, David, Joe

UNIQUE(Products[Color]) returns a list of Color column values from the Products table without duplicates.

Syntax

UNIQUE( this-list )

Description

UNIQUE() returns the items of this-list (a list of any type) in the original order with duplicates removed.

Return Value

A new list containing the unique items of this-list.

See Also

INTERSECT(), LIST(), SORT(), TOP()

Did this answer your question?