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