Hi

Try this formula:

=(LARGE(B1:B80,1)+LARGE(B1:B89,2)+LARGE(B1:B80,3)+ LARGE(B1:B80,4)+LARGE(B1:B80,5))/5

Regards,
Per

"Charlie" skrev i meddelelsen
...
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