help with 12 week rolling average
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
|