Thread: Best average for 5 years out of 8
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default Best average for 5 years out of 8
=AVERAGE(LARGE(A1:H1,{1,2,3,4,5}))
This is an array formula so commit it with CTRL+SHIFT+ENTER not just ENTER
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Wendy" wrote in message
...
I am trying to figure out how to calculate an average of the best five
years
out of 8.

My first example is 0, 3, 3, 5, 5, 3, 5, 5 I would expect my average to
be
4.6.

Another example is 5, -2, -2, -2, -2, 0, 0, 0 I would expect my average
to
be -0.6




Reply With QuoteReply With Quote