Functions
UNIQUE
Returns unique rows or columns from an array
Try it
When to use it
When should I use UNIQUE?
Use UNIQUE to extract a de-duplicated list from an array — useful for building dropdown source lists, counting distinct items, or eliminating repeated entries before aggregation.
Used in
Syntax
UNIQUE(array, [by_col], [exactly_once])Examples
=UNIQUE({1,2,2,3,3,3}) // => 1
=UNIQUE({1,2,3}) // => 1
=UNIQUE({7,7,7}) // => 7