how do you select multiple minima in Excel
 

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

how do you select multiple minima in Excel
 

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

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