NthMaxList

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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.