NthMaxList

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.

Notes

• See MaxList to return the highest value of the specified numerical expressions.
• See MaxList2 to return the second highest value of the specified numerical expressions.