how do you select multiple minima in Excel

J

jd110110

I'm looking for a way of selecting the 2nd or 3rd smallest value in a range
of data, not just the min.
 
B

Biff

Hi!

=SMALL(A1:A10,1) is the same as =MIN(A1:A10)

2nd smallest: =SMALL(A1:A10,2)
3rd smallest: =SMALL(A1:A10,3)
etc

Biff
 
Top