MS Excel: Extracting 2 or more highest numbers from a list

[daggers]

Hi,

Don't know if this is a stupid quesiton, but here goes:

If I want the highest number from a list, I would use
=MAX(Ax:Ay).

However, how do I get Excel to extract the 2 highest numbers from the same list?? Or the 3 highest etc.

Thanks

 

[xlhelp]

=large(ax:ay,1)
=large(ax:ay,2)

etc.

 

[DaleWatson123321]

=Large(list,1) for your 1st largest,
=Large(list,2) for your 2nd largest,
=Large(list,3) for your 3rd largest, etc.

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca