C
Charliechoo
I have an excel spread sheet in column A I have week commencing dates for a
whole year and column B contains the sales data for each of these weeks. I
need excel to give me a continual rolling average for the latest 4 weeks
entered, so that when I enter another week the first week "drops" out and a
new average is calculated.
I am being told that this enters into the realms of programming and nearly
impossible to do! Can anyone help?
Charlotte
X
whole year and column B contains the sales data for each of these weeks. I
need excel to give me a continual rolling average for the latest 4 weeks
entered, so that when I enter another week the first week "drops" out and a
new average is calculated.
I am being told that this enters into the realms of programming and nearly
impossible to do! Can anyone help?
Charlotte
X