Smallest 3 numbers if you have unique (no repeats)
= small(b3:b10,1)
= small(b3:b10,2)
= small(b3:b10,3)
However if you have numbers repeat then
Smallest
= min(b3:b10)
2nd smallest
=min(if(b3:b10small(b3:b10,2),b3:b10))
array entered (ctrl+shift+enter)
3rd smallest
=min(if(b3:b10small(b3:b10,2),b3:b10))
array entered (ctrl+shift+enter)
"Pete" wrote in message
...
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
|