nth smallest value

Generic formula
=SMALL(range,nth)
Summary
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:
=SMALL(times,F5)
which returns the nth smallest times using the value in column F for n.
Explanation
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 1st smallest value).
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.