Hi.
I have a large spread of data for example cells A1 - A100.
I wish to take a moving average of cells A1-A100 and place this data in cells B1-B100. I then want to take a moving average of the results in cells B1-B100and place them in the same cell arrangement, effectively taking a moving average of a moving average within the same cell arrangement.
Depending upon the frequency spread of my data i may need to do this up to 10 times and place the 10th moving average in the same column as the first moving average replacing the data the original moving average data.
Any help would be much appreciated!
Thanks in advance,
Phil
Bookmarks