Link to home
Start Free TrialLog in
Avatar of Amit
AmitFlag for United States of America

asked on

excel 2010 year over year calculation

Hi,

I have a following columns in a spreadsheet and I want to do year over year calculations. so the growth in 2011 is 50% compared to 2010 etc

2010      50
2011      75
2012      86
2013      95
2014      125
2015      300

How can I do this easily in excel 2010 and excel 2013 (i am going to install it soon)

Is there a one click way to do this, like what we can do it tools like Tableau

thanks
-anshu
ASKER CERTIFIED SOLUTION
Avatar of Kimputer
Kimputer

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amit

ASKER

thank you very much for all your help