RANK (PQL - xl)
This function returns the rank of a number in a set of numbers. If you were to sort the set, the rank of the number would be its position in the list
- Library: PQL \ Spreadsheet \ Compatibility
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
RANK(number, ref, OPTIONAL order)
Function Arguments
Name | Description | Type | Optional |
number | Number whose rank you want to return | Number |
|
ref | Reference to the set of numbers | CellRange |
|
order | How the number is ranked, either in descending order (0 or omitted) or ascending order (non-zero value) | Number | Y |
Comments
This function is the same as the Microsoft Excel 'RANK' function - using the same inputs, logic and outputs.