Thread: average of highest 48 of 52 radom numbers with duplicate low #'s
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default average of highest 48 of 52 radom numbers with duplicate low #'s
You may use this array formula:
=AVERAGE(LARGE(A1:A52,ROW(1:48)))
Enter it with Crt+Shift+Enter

"LCB" wrote:

I must determine out of 52 radom numbers the average of the 48 highest even
if one or more of the lowest numbers is repeated 7 times without exempting
the 3 out of the 7 that must be included in the 48 to extract the average.

Reply With QuoteReply With Quote