Calculate Minimum numbers

[Pete]

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

[Bob Phillips]

=SMALL($B$3:$B$10,1)
=SMALL($B$3:$B$10,2)
=SMALL($B$3:$B$10,3)

--
HTH

Bob Phillips

"Pete" <Pete@discussions.microsoft.com> wrote in message
news:ECB7EC5F-9389-4F58-810C-8A36AC4D15DB@microsoft.com...
> 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

[N Harkawat]

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:b10>small(b3:b10,2),b3:b10))
array entered (ctrl+shift+enter)

3rd smallest
=min(if(b3:b10>small(b3:b10,2),b3:b10))
array entered (ctrl+shift+enter)


"Pete" <Pete@discussions.microsoft.com> wrote in message
news:ECB7EC5F-9389-4F58-810C-8A36AC4D15DB@microsoft.com...
>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