Compare addresses in two worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

CoaxCt said:
I have two worksheets with hundreds of addresses in one column in
Click to expand...
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
Click to expand...
other important information and the formatting, etc. are different.
Is there an easy way to do this in Excel?
 
Back
Top