Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Year over Year

Status
Not open for further replies.

Rseven

Technical User
Mar 7, 2006
41
US
Hello All,
I am trying to do a year over year calculation based on month to month data which is represented in another cell for a dashboard. I have the YoY calculations working but because that % needs to be represented on a seperate worksheet in a dashboard I can only get the current month %. What I'd like to have it do is compare MoM on a rolling basis. For example when April Month-end gets populated I would like the calculation to look at the April cells without having to change the calculation manually. Is this possible?

Thanks in advance

MTD YTD MTD YTD YoY
Jan-12 1,259,004 1,259 Jan-13 6,959 6,959 -452.76%
Feb-12 7,476,538 8,736 Feb-13 4,443 11,402 -30.52%
Mar-12 4,621,829 13,357 Mar-13 4,411 15,813 -18.38%
Apr-12 4,305,276 17,663
May-12 6,573,996 24,237
Jun-12 7,088,530 31,325
Jul-12 11,946,233 43,271
Aug-12 3,965,033 47,236
Sep-12 5,560,432 52,797
Oct-12 161,582,186 214,379
Nov-2 19,245,328 233,624
Dec-12 17,063,466 250,688

 
I apologize it was formatted better before i posted it.
 
Hi,

We cannot see what is in your mind unless you post it in your thread.

Please take one row and show
1) what it is your are calculating and
2) what formula(s) you are using to effect that calculation and
3) the result(s) of your calculation and
4) what you believe the expected result(s) should be.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top