I have a lists of data in which I need only to display the most current moving average in the range of data. I have monthly data that I am able to use the Moving Average function in Data Analysis. However, the output is a list of moving averages. I do not need past data to be displayed, I only need to display the most recent 3 month moving average. My data is as follows:
Input column Output column
2.6 N/A
2.6 N/A
2.6 2.6
2.4 2.5333333
blank cell 2.5333333
blank cell 2.5333333
I want to display only the most recent moving average (the 2.533333 from the 2.4 latest input).
I am trying to automate various functions to save time. I appreciate any help.
Unfortunately, I cannot attach the workbook as it is on a stand alone system with sensitive data.
Thank you!
Bookmarks