| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with 12 week rolling average
Thanks guys now it's working
On Jan 29, 2:56 am, "MartinW" wrote: Hi Dominick, Another way to approach it is to put this in L2 =IF(L1="","",AVERAGE(A1:L1)) Then drag it across as far as is needed. Now as you add data in M1,N1,O1 etc. your floating 12 week average will appear in the cell beneath it. HTH Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
| rolling average | Excel Worksheet Functions | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Macro to insert copied cells | Excel Discussion (Misc queries) | |||
| 52 week average based on date | Excel Discussion (Misc queries) | |||
Threaded Mode
