Hi Guys,
New to the forum and a pleasure to be here.
I am in need of you help.
I am working with a table of 2 columns:
Column 1: Month/Year (Jan/2000, Feb/2000, ... , Feb/2020)
Column 2: % anual inflation
I am trying to create a formula to include the average of the 12 months prior of 2016 and after 2017 the average of the calendar year (Jan- Dec)
Example:
If I need to work with the month of July 2014 the formula needs to indicate the average of inflation corresponding to the 12 months prior July 2014 (range: July 2013 to June 2014) this done by year. And after the year 2017 include the average of Jan - December, instead of the months prior.
Any help would be much appreciated!
Thanks,
LC
Bookmarks