| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average between dates considering leap years. | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
| Calculate Years/Months Between Dates and then Average | Excel Discussion (Misc queries) | |||
![Bernard Liengme[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
