Return the 2nd smallest number from a range 1

[Wray69]

OK, seems like I saw how to do his here not that long ago, but I cant find it for the life of me. I know MIN will bring back the smallest number in the range, but what could I do if I wanted to bring back the 2nd and 3rd smallest numbers in the range?

Regards,

Wray

 

[Wray69]

Nevermind.... I figures out... =small(a1:a10,2)


That Excel Help file does wonders.... heh


Cheers,

Wray

 

[KenWright]

Hi Wray,

And if you want more than 1 number, then just specify them all:-

Select 4 cells, put in
=SMALL(A1:A10,{2;3;4;5}) and array enter it.

Above is if you select 4 cells across a number of rows, eg B5:B9. If you select across columns, eg B5:E5 then you need to change the commas to semicolons:-

=SMALL(A1:A10,{2,3,4,5}) and array enter it.

or

=SUM(SMALL(A1:A10,{2;3;4;5}) if you just want the sum. or
=SUM(SMALL(A1:A10,{2,3,4,5}) if across rows

Regards
Ken.............

 

[Wray69]

Thanks for the tutorial Ken, I need all the help I can get sometimes.... LOL

Heres a star for showing me how useful SMALL is...

Cheers,

Wray

 

[KenWright]

I need as much of that help as I can get too

Rgds
Ken............