Finding 2 minimum values

  • Thread starter Thread starter Dan KErn
  • Start date Start date
D

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
 
Dan KErn said:
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
Click to expand...

=SMALL(A1:A100,2)
 
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.
 
Back
Top