nth smallest value

An excel formula to nth smallest value


Related Functions

 nth smallest value

To get the 2nd smallest value, 3rd smallest value, 4th smallest value, and so on, from a set of data, you can use the SMALL function.

In the example shown, the formula in G5 is:


How this formula works

The SMALL function is fully automatic — you just need to supply a range and an integer for"nth" to specify the ranked value you want.

The official names for these arguments are "array" and "k".

Note: you can also use the MIN function to get the smallest value (i.e. the largest value).

0 votes. 0 / 5