Finding 2 minimum values

[Dan KErn]

Does anyone know if it's possible to find the TWO minimum
values in a range? I know how to use MIN to find the
first, but is there any way to find a second (or more)
minimum after the first?

Thanks,
Dan Kern

 

[Paul]

Does anyone know if it's possible to find the TWO minimum
values in a range? I know how to use MIN to find the
first, but is there any way to find a second (or more)
minimum after the first?

Thanks,
Dan Kern

=SMALL(A1:A100,2)

 

[Arvi Laanemets]

Hi

=SMALL(Range,1) returns same value as MIN()
=SMALL(Range,2) returns the nearest to minimal, or same, when there is a
second value equal to MIN()
etc.

 

[Don Guillett]

try

=SMALL(B2:B10,2) 2nd smallest number in the second column (3)