Returns the Nth highest value of the specified numerical expressions.
Usage
NthMaxList(N, Value1, Value2, Value3, etc.);
Where:
- N - a numerical expression, indicating the rank of the value to be returned.
- Value1, Value2, Value3, etc. - numerical expressions.
Example
NthMaxList(4, -15, -5, 0, 6, 12);
Will return a value of -5, the fourth highest value of the specified numerical expressions.