Hello Zone,

Sorry, I have wrongly stated as moving the column up and down, should be
moving rows within the column up and down.

I would like all the formulas in each row of column A unaffected by this
movement.

Any idea how to do it ? Previously I have leaned about how to use OFFSET
formula when dealing with A2 = C2-B2 . Can =OFFSET( ) formula be used in this
situation ?


Thanks

Low


A36B58K641


"Zone" wrote:

Low, I think people are not understanding the problem as you have
stated it. Columns cannot be moved "up and down". Columns can only be
moved right or left. Are you moving cells within this columns? If you
are talking about moving rows up or down, the formulas should adjust
themselves, so we are not understanding your question. James
Mr. Low wrote:
Dear Sir ,

I have the formula at =IF(B2=C2,"Yes","No") at A2 and copy downwards to A20.

I would like the formula to be able to compare each cell at column B and C
even if I move either colu7mn up and down.

Currently I need to copy the formula all over again if any cell in which the
formula refers to is moved.

A B C
1 Ref A Ref B
2 Yes xxxx xxxx
3 Yes xxxx xxxx
4 No xxxx xxxx
.
.
20 Yes xxxx xxxx


Thanks

Low


--
A36B58K641