SMALL function


Return the nth smallest value.



=SMALL( arrayk )


required arguments:

array A range of cells.
k An integer that specifies the position from the smallest value.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.