UNIQUE

Returns an array of unique values from the specified range.

Syntax

UNIQUE( ReferenceOrArray range, [Logical byCol], [Logical exactlyOnce] ) → Array

Parameters

range

Required. The range or array to filter.

byCol

Optional. FALSE (default) to compare rows, or TRUE to compare columns.

exactlyOnce

Optional. FALSE (default) to return all distinct values, or TRUE to return values listed only once in the source range.

Remarks

Results spill into cells adjacent to the one that calls UNIQUE. If they are occupied, the formula returns #SPILL error.

See Also

Function Reference
SORT Function
FILTER Function