UNIQUE
Returns a list of unique values in a list or range.
| Category | DynamicArray |
| Syntax | UNIQUE(array, [by_col], [exactly_once]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
array | Required | The range or array from which to return unique rows or columns. |
by_col | Optional | TRUE to return unique columns; FALSE (default) to return unique rows. |
exactly_once | Optional | TRUE to return values that occur exactly once; FALSE (default) to return all distinct values. |
Example
UNIQUE(array, by_col, exactly_once)
Auto-generated from the EngCanvas function registry.