Compare addresses in two worksheets

[CoaxCt]

I have two worksheets with hundreds of addresses in one column in both. I would like to compare the addresses between the two spreadsheets and determine

1. Which addresses matc
2. Which addresses don't matc
a. Of thses, which come from spreadsheet A and which from spreadsheet B

I haven't imported into a database because they are set up with other important information and the formatting, etc. are different. Is there an easy way to do this in Excel

Thanks

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm

HTH
Frank

 

[Bernie Deitrick]

Coax,

With both workbooks open, in a cell next to your first address, type
=MATCH(
then click on the cell with the address, then type a comma, then
click on Window and select the entire column with addresses, then type
, False)
and press enter. Copy that formula down for as far as your addresses
exist.

Any formula returning an error means that the address doesn't exist in
the other database. Any formula returning a number shows the row in
the other workbook where its mate resides.

Repeat for the second workbook, and you are done.

HTH,
Bernie
MS Excel MVP

I have two worksheets with hundreds of addresses in one column in

both. I would like to compare the addresses between the two
spreadsheets and determine:

1. Which addresses match
2. Which addresses don't match
a. Of thses, which come from spreadsheet A and which from spreadsheet B.

I haven't imported into a database because they are set up with

other important information and the formatting, etc. are different.
Is there an easy way to do this in Excel?

 

[CoaxCt]

Thanks for the quick reply. I will try this.