| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rolling Averages
I would like to create a summary page with the 3 month rolling average of
sales. I have all the sales, profit and salesperson data compiled on 1 worksheet. I would like to use a drop down menu on the summary (already set it up by months) to choose a month of the year and then have the average of the previous 3 months data displayed. Is this possible? and if yes, How? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling Averages | Excel Discussion (Misc queries) | |||
| Dynamic reporting rolling averages | Excel Worksheet Functions | |||
| rolling | Excel Worksheet Functions | |||
| Need help creating 3-month rolling averages... | Excel Discussion (Misc queries) | |||
| Z Chart i.e. top rolling annual bottom rolling monthly middle cum. | Excel Worksheet Functions | |||
Threaded Mode
