Determine average of largest 5 numbers in a column.
Seems to be a typo somewhere here?
--
Bernard
"T. Valko" wrote in message
...
(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
|