Find duplicate entries

[Guest]

I have two columns in an Excel spreadsheet that consist of an address in each
column. Most of the addresses are identical but I wish to find the rows
where the addresses are not identical.

Is there a way to do this.

Thanks for any help.
Kris

 

[Guest]

Hi,

One way would be to conditional format one column so it highlights if it
doesn't equal the corresponding cells in the other column.

HTH
Ron

 

[Dave Peterson]

If you want help working with duplicates, take a trip to Chip Pearson's
site:

http://www.cpearson.com/excel/duplicat.htm

He has a bunch of techniques for working with duplicates.

 

[Guest]

Can you explain how I would go about doing that.

Thanks