# nth smallest value in Excel

This tutorial shows how to calculate nth smallest value in Excel using the example below;

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.

## Formula

=SMALL(range,nth)

## Explanation

In the example shown, the formula in G5 is:

=SMALL(times,F5)

### 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).