I've build a pivot data set which will be updated on a weekly basis. I would like to capture the latest 4 data points each time and calculate the average, succeeded with this formula: =AVERAGE(OFFSET(F6;COUNT(F6:F162)-1;0;1))
Now I would like to do the same with the 4 weeks prior to these last 4 weeks.
Is there a formula to do this?
Now I would like to do the same with the 4 weeks prior to these last 4 weeks.
Is there a formula to do this?