| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create a 12 month rolling average
I have a data sheet with 20 columns that represent 20 months of data (starts
at column b). Monthly data is added for each month. I want to create a rolling average. The data starts at Row 3 and ends at row 737. E.g. for Dec 2007, the rolling average would be Jan 2007 to Dec 2007. e.g. for Jan 2008, the rolling average would be Feb 2007 to Jan 2008, etc, Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
| rolling 12 month average | Excel Worksheet Functions | |||
| Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
| How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
| How can I create a rolling average between 2 values? | Excel Worksheet Functions | |||
Threaded Mode
