(Excel 2007)

Try this:

=AVERAGE(MMAX(A1:A80,5))

--
Biff
Microsoft Excel MVP


"Charlie" wrote in message
...
I would like to be able to determine the average of the largest 5 numbers
in
a column of 80 numbers. How to do??

(Excel 2007)

Thanks for your help.
--
SRX44