Find duplicate entries
 

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

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

"kharrison" wrote:

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

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.

kharrison wrote:

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

--

Dave Peterson

Can you explain how I would go about doing that.

Thanks

"Airfive" wrote:

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

"kharrison" wrote:

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