troubleshooting Question

excel 2010 year over year calculation

Avatar of anshuma
anshumaFlag for United States of America asked on
Microsoft Excel
2 Comments1 Solution419 ViewsLast Modified:

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

KimputerIT Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros