Calculating a Moving Average

[agentred]

Hi folks,

OK Solved! I inserted my code below if anyone needs to see it, it's pretty messy but does the job. Thanks again,
....
..
....


I'm trying to calculate a moving average, as well as a modified moving average, but I'm getting stuck pretty early on.

For those who don't know, a 3 (or 5, or 10) point MA is the average of the last 3 (or 5 or 10) values of a time series. I have a simple time series with a header in column B, I'd like to have the user input how many points they'd like in cell E1 and have the moving average calculated until the bottom of the series.

Please Login or Register  to view this content.