Forum Discussion
Rolling 12-Month Average
I want to have a column showing a rolling 12-month average for each individual contributor. The table is laid out like this (showing a full 12 months with the previous months' columns hidden): Name ...
My formula was
= BYROW(TAKE(contribution,,13), AVERAGE)An obvious question might be why I have selected 13 columns when an average over 1 year is required? To answer my own question, the answer is that column C is hidden and contains blank cells. That makes inserting a column before Jan-25 a less uncertain process.