UNIQUE()

Unique items in list

Returns a list of items in the original order with duplicates removed.

Sample usage

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

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

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

Syntax

UNIQUE(list)

  • list - A  list of any type. .

See also

INTERSECT()

LIST()

SORT()

TOP()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false