Running percent change formula for time series

chronot

New Member
Joined
Jan 5, 2018
Messages
1
Hello!

This is my first post in this forum. I am very happy to be part of it and learn a lot of Excel from all your knowledge and experience :)

Is there a way to automatically change the cell references in order to calculate the running percent change, when the year changes? (see row 3)
For example: For 2016, the formula was the sum from January 16 to the corresponding month of the year divided by sum of the same dates in 2015, multiplied by 100 minus 100.

(Sum from January 2016 to say March 2016) / (Sum from January 2015 to March 2015) * 100 - 100

But, in January 2017 (column Z), I need to manually change the cell references so that the formula can calculate the running percent:

If I have a long times series, say 30 years, it would be tedious to change the formula each year, so every help will be very useful.

An example of the file is available at https://drive.google.com/open?id=1wNu9VrCXTXrDTsdTIQKNg5LkMhE8cAu7

Thank you very much for your valuable help.

Greetings from Paraguay, South America
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,122,553
Messages
5,596,807
Members
414,104
Latest member
imamalidadashzada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top