Returns an array of unique values from the specified range.
Syntax
 Copy Code
|
|---|
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.