#### PAul Birch

##### New Member
Hi All

I have an excel spreadsheet that list performance month on month over a ever growing period. I am trying to insert a cell that will show the difference between the last filled in cell and the cell that was 12 months before. The spreadsheet looks like this

Name Jan08 Feb08 mar08 ..... jan09 Feb09 Mar09 Year on year

Paul .... 5...... 6 .....7 .............6....... 6.................. ?

I cannot work out the formula i would need to fill in year on year

Any help would be greatly appreciated

Paul

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
Your Date Row is a named range called "DATES"
'You're currently in Column Z
'The Dates row is on row 2
'You're currently on row 8

something like this should get your number from the period last year.

=sumif(dates,date(year(z2)-1,month(z2),Day(z2)),\$A8:Y8)

...I think...

Hi Thanks for that

Unfortunately it gives me #Name , Also i am unsure how this would find the last filled cell.

thanks for trying

Replies
0
Views
489
Replies
6
Views
345
Replies
11
Views
1K
Replies
11
Views
556
Replies
16
Views
723

1,196,357
Messages
6,014,768
Members
441,847
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back