Hello,
I work for a business and I keep and update daily statistics for our supply and demand. Currently I have a list by days of the week with a drop down list that I can view all Mondays or Tuesdays or any other days and take averages. I would like to automatically generate all of this because it has become a bear to go through every day and do averages manually.
I am looking for a rolling weekly average of 5 weeks and 10 weeks but how my data is set up makes that a little difficult.
A B
Monday 397
Tuesday 300
Wednesday 400
Thursday 280
Friday 300
Saturday 200
Sunday 86
Monday 280
... ...
... ...
I would like to create a rolling average of every day of the week but I can't seem to figure out how to separate each day of the week when they are all in 1 column.
I want a
A B C
Monday 5 Week Rolling Avg 10 Week Rolling Avg
Tuesday 5 Week Rolling Avg 10 Week Rolling Avg
Wednesday 5 Week Rolling Avg 10 Week Rolling Avg
Can anyone help?
Bookmarks