Finding 2nd, 3rd, 4th and 5th Maximums.

[news.mweb.co.za]

Hi there guys.
I need to know what the formula would be to find a 2nd, 3rd etc maximum.
SO basically like this.

14
16
3
9
1

I would get - 1st Max - 16, 2nd Max - 14 etc

I can't go sort ascending or descending as the setup of the program is
crucial. So i just need the 5 or so maximums from a list.

Can ANYONE at all help me with this.
THanks,
Philip

 

[Chip Pearson]

Philip,

See the LARGE function. E.g.,

=LARGE(A1:A10,2)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Harlan Grove]

I need to know what the formula would be to find a 2nd, 3rd etc
maximum.

....

Read how to use the LARGE worksheet function in online help.