Yes, I am inserting or deleting cells in one column or the other to align the
inventory because the 2 lists aren't completely identical. I then subtract
the 2 prices and if I get 0, there is no price change. Basically, I am
comparing 2 lists but I have to align them first. I can't think of another
way to do this.

Thanks,

"Bernard Liengme" wrote:

What to try again? I am confused. What is meant by "moving A23 up or down"?
Do you mean insert or delete rows?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"BradleyP" wrote in message
...
I have an inventory spreadsheet where I compare the values in 2 columns to
make sure they equal 0. If the 2 values in each row to equal 0 when I
subtract one from the other (A23-B23), this lets me know that the
inventory
price has not changed. However, because the new inventory list may have
more
or less items that the current inventory list, I have to move cells up or
down to align the similar inventory parts.

I want to put a column to the side where I subtract current inventory
value
from new inventory value and get a result of 0. But when I move one column
up
or down, the formula changes accordingly. I want to be able to freeze the
formula column so that it always says "A23-B23" even when I move A23 up or
down.