Dynamic Moving Average Formula

  • Thread starter Thread starter STEVEN TAYLOR
  • Start date Start date
S

STEVEN TAYLOR

Hi All,

I would really appreciate any help in trying to solve the following problem:

I have a forecast model and I am trying to create a dynamic moving average.
Specifically, I need a formula to look at a cell, which contains the
current month i.e. June. It then needs to look up the month in a column,
which contains all the months of the year. Once it finds the match, it needs
to take the value in the next column over as well as the value of the prior
two months before it and calculate the average of these three months.

The calculation needs to update whenever the month value is changed.

Any suggestions would be greatly appreciated.

Thanks,

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top