Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rolling Average
I have a sheet that needs to calculate a 53 week rolling average. Column A has the week number; Column B has the data to be averaged. I'm familiar with the offset function when charting and wonder if this can be replicated for calculating an average to match my chart. -- SPenney ------------------------------------------------------------------------ SPenney's Profile: http://www.excelforum.com/member.php...fo&userid=1079 View this thread: http://www.excelforum.com/showthread...hreadid=510252 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
Rolling 3 mth Average | Excel Worksheet Functions | |||
How do I create a rolling average chart, adding most recent data? | Charts and Charting in Excel | |||
Rolling Average | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions |