S
SPenney
I have a sheet that needs to calculate a 53 week rolling average.
Column A has the week number; Column B has the data to be averaged.
I'm familiar with the offset function when charting and wonder if this
can be replicated for calculating an average to match my chart.
Column A has the week number; Column B has the data to be averaged.
I'm familiar with the offset function when charting and wonder if this
can be replicated for calculating an average to match my chart.