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
Number whose rank you want to return
Reference to the set of numbers
How the number is ranked, either in descending order (0 or omitted) or ascending order (non-zero value)
This function is the same as the Microsoft Excel 'RANK' function - using the same inputs, logic and outputs.