UNIQUE (PQL - xl)
This function returns a list of all the unique values in a cell range
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
UNIQUE(array, OPTIONAL by col, OPTIONAL exactly once)
Function Arguments
Name | Description | Type | Optional |
array | Specifies the range or array from which you want to return unique values | StringOrNumber |
|
by col | Specifies the logical value that indicates how to compare. If this argument is TRUE, it refers to 'by column' and if FALSE, it refers to the 'by row' | StringOrNumber | Y |
exactly once | Specifies a logical value. If this argument is TRUE, it will return unique values that occur only once. In case the value is FALSE, all the unique values will be included in the result | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'UNIQUE' function - using the same inputs, logic and outputs.