LARGE (PQL - xl)
This function returns the nth largest value in a data set, where n is specified
- Library: PQL \ Spreadsheet \ Statistical
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
LARGE(array, k)
Function Arguments
Name | Description | Type | Optional |
array | Array from which to return the nth largest value | StringOrNumber |
|
k | The position (from the largest value) for which to return the value (for example, 5 to return the fifth largest value). Must be equal to or less than the number of items in the array | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'LARGE' function - using the same inputs, logic and outputs.