This function returns the rank of a number in a set of numbers
- Library: PQL \ Spreadsheet \ Statistical
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
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.EQ' function - using the same inputs, logic and outputs.