Expressions: Sorting Functions

Nth

Use this function to sort the parameters A,B,C... into ascending number sequence and select the Nth one.

This can be used to find the "Nth smallest".

If N is negative then the Nth from last is selected, so this can be used to find the "Nth largest"

NthIndex

Use this function to sort the parameters A,B,C... into ascending number sequence and select the index of the Nth one.

This can be used to find the item which is the "Nth smallest".

If N is negative then the Nth from last is selected, so this can be used to find the item which is the "Nth largest"

NthDistinct

Use this function to sort the parameters A,B,C... into ascending number sequence and select the Nth distinct one.

This can be used to find the item which is the "Nth distinct smallest".

If N is negative then the Nth distinct from last is selected so this can be used to find the item which is the "Nth distinct largest".

The parameters can also be specified as numeric lists.

NthDistinctIndex

Use this function to sort the parameters A,B,C ... into ascending number sequence and select the index of the Nth distinct one.

This can be used to find the index of the item which is the "Nth distinct smallest".

If N is negative then the Nth distinct from last is selected so this can be used to find the index of the item which is the "Nth distinct largest".

The parameters can also be specified as numeric lists.