Avatar of anshuma
anshuma
Flag 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
Microsoft Excel

Avatar of undefined
Last Comment
anshuma

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kimputer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
anshuma

ASKER
thank you very much for all your help
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck