Thread: how can get average of 3 max values out of 7 values in a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
  
Posts: 695
Default how can get average of 3 max values out of 7 values in a row
=AVERAGE(LARGE(A2:A8,{1,2,3}))


"Mobin" skrev:

how can get average of 3 max values out of 7 values in a row
Reply With QuoteReply With Quote