NthMinList

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 lowest value of the specified numerical expressions.

Usage

NthMinList(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

NthMinList(4, -15, -5, 0, 6, 12);

Will return a value of 6, the fourth lowest value from the specified numerical expressions.

Notes

See MinList to return the lowest value of the specified numerical expressions.
See MinList2 to return the second lowest value of the specified numerical expressions.