Thread: Average highest 16 numbers on a column of 32 numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frank[_10_] Frank[_10_] is offline
external usenet poster
  
Posts: 1
Default Average highest 16 numbers on a column of 32 numbers
I have a column of numbers, each with a value of 25 or less. I need a formula
to total and average the highest 16 numbers in the column. Any ideas? Thanks.
--
Live long and prosper.
Reply With QuoteReply With Quote