Excel Year over Year

[Rseven]

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

 

[Rseven]

I apologize it was formatted better before i posted it.

 

[dhookom]

Learn how to use TGML. It's been made very easy and convenient.

Duane
Hook'D on Access
MS Access MVP

 

[SkipVought]

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]
Just traded in my old subtlety...
for a NUANCE![/sub]