comparing cells in two columns ?

[TimR]

How doe you compare the value of cells is column C to the same row cell in
column A...and if the value is not the same...replace column/row cell A with
the value in column/row cell C ?

 

[David Biddulph]

If you're going to change A if they're not the same, then you don't need to
compare. In A1 put =C1, and copy down.

 

[TimR]

Sorry...I guess I was not clear...have a worksheet that has a static column
A...rows 1-2000. From time to time I insert an updated column C with some
new values in some of the rows..although most stay the same.

Can I 'automatically' change the value in the original column A row xx to
the new value in the new column C...matching row xx ?

In other words...I have a list of people's names that have an address
also...but from time to time...the people move but the address of the home
stays the same...if I have a new list that includes both the old people who
didn't move but also new people that have moved into the area...can I remove
the old 'names' only in Column A and replace them automatically with the new
names appearing in Column C ? ...the addresses of course stay the same

Thanks, Tim

 

[David Biddulph]

Yes. Read my answer again.
--
David Biddulph

Sorry...I guess I was not clear...have a worksheet that has a static
column
A...rows 1-2000. From time to time I insert an updated column C with some
new values in some of the rows..although most stay the same.

Can I 'automatically' change the value in the original column A row xx to
the new value in the new column C...matching row xx ?

In other words...I have a list of people's names that have an address
also...but from time to time...the people move but the address of the home
stays the same...if I have a new list that includes both the old people
who
didn't move but also new people that have moved into the area...can I
remove
the old 'names' only in Column A and replace them automatically with the
new
names appearing in Column C ? ...the addresses of course stay the same

Thanks, Tim