Thread: Determine average of largest 5 numbers in a column.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Determine average of largest 5 numbers in a column.
Hi,

Try this

=AVERAGE(LARGE(A1:A80, {1,2,3,4,5}))

Mike

"Charlie" wrote:

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
Reply With QuoteReply With Quote