D
Dewayne
I calculate an average in cell G19 that includes the lastest 12 months
values. Each month I need to update the formula to exclude the first of the
last 12 months and include the new month. Currently I am doing this manually
each month. Is there a way to automatically update the formula to include
only the last 12 months in the average when new data is entered into a new
cell?
Thanks for any suggestions.
values. Each month I need to update the formula to exclude the first of the
last 12 months and include the new month. Currently I am doing this manually
each month. Is there a way to automatically update the formula to include
only the last 12 months in the average when new data is entered into a new
cell?
Thanks for any suggestions.