UNIQUE
Returns a list of unique values in a list or range
Syntax
UNIQUE(array, [by_col], [exactly_once])
Parameters
- array: Required. The range or array from which to return unique rows or columns
- by_col: Optional. FALSE to compare by row (default), TRUE to compare by column
- exactly_once: Optional. FALSE to return all distinct (default), TRUE to return values occurring exactly once
Example
=UNIQUE(A1:A10)