Need to calculate moving average of column B, but I want to experiment by inputting different periods. I've attached a worksheet where the input cell is D4.
The MA calculations can go into column D. Obviously the first MA data point will depend on the period in D4.
Example calculation: Moving Average is 3. Therefore the first cell with data (2) will be D7.
I very much appreciate your help!
Bookmarks