| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Best average for 5 years out of 8
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) | |||
Threaded Mode
