NthMinList

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.