View Single Post
  #1   Report Post  
Pete
 
Posts: n/a
Default Calculate Minimum numbers

I have a need to calculate the 3 smallest numbers in a set of 7. I have tried
the min function but this only gives me one number. The nubers are listed in
(B3:B10) my formula is in (B12). Some cells can be blank and some or a
negitive, while a third senerio would be that you could have repeatitive #'s
(I.e -13,_,_,2,_,-2,-13).

Any thoughts
--
Pete