E
ernie - willcox
I’m trying to compare last years price sheet to this years and note the
changes in the cost. I don’t know how to do this.
I have two different methods set up but I can’t seem to get them to work.
Method one is that I have two price sheets with identical headers and
columns. My part number on sheet 1 would be the same as the part number in
sheet two. Is there a way to compare the two sheets and place a value or
statement showing Increase in another column on the newest sheet?
Sheet one (old price list)
A B
Part Number Cost
Sheet two (new price list)
A B C D
Part Number Cost Increase Difference
Method two is that I’ve combined the data from both spread sheets and sorted
them.
My value in column A is my part number; my value in column B is my cost. I
need to know is if my cost increased and place the change in a new row
indicating the change.
Here is what the sheet would look like
A B C D
2522 33.05 2008
2522 31.22 2009 Decrease
2523 10.00 2008
2523 12.00 2009 Increase
2524 10.00 2008
2524 10.00 2009 Same
Can this be done? I hope this makes sense!
Thank you.
changes in the cost. I don’t know how to do this.
I have two different methods set up but I can’t seem to get them to work.
Method one is that I have two price sheets with identical headers and
columns. My part number on sheet 1 would be the same as the part number in
sheet two. Is there a way to compare the two sheets and place a value or
statement showing Increase in another column on the newest sheet?
Sheet one (old price list)
A B
Part Number Cost
Sheet two (new price list)
A B C D
Part Number Cost Increase Difference
Method two is that I’ve combined the data from both spread sheets and sorted
them.
My value in column A is my part number; my value in column B is my cost. I
need to know is if my cost increased and place the change in a new row
indicating the change.
Here is what the sheet would look like
A B C D
2522 33.05 2008
2522 31.22 2009 Decrease
2523 10.00 2008
2523 12.00 2009 Increase
2524 10.00 2008
2524 10.00 2009 Same
Can this be done? I hope this makes sense!
Thank you.