Parameter List
Syntax
UNIQUE(data,
[by_column]
, [exactly_once]
)data
The range or {data} to get the unique rows or columns. For example: A1:B10.
[optional] by_column
The comparison method. TRUE implies the columns will be compared against each other and return the unique ones. By default or FALSE it returns the unique rows.
[optional] exactly_once
The logical value to define whether the function should get rows or columns that appear just once in data. By default or FALSE it returns all unique rows or columns.