CHOOSEROWS (PQL - xl)
The function returns the specified rows from an array
- Library: PQL \ Spreadsheet \ Lookup
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
CHOOSEROWS(array, row num1, OPTIONAL row num2)
Function Arguments
Name | Description | Type | Optional |
array | Refers to the array containing the rows to be returned | StringOrNumber |
|
row num1 | Refers to the first row number to be returned | Number |
|
row num2 | Refers to the additional row numbers to be returned | Number | Y |
Comments
This function is the same as the Microsoft Excel 'CHOOSEROWS' function - using the same inputs, logic and outputs.