Compare addresses in two worksheets

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?

Thanks

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

HTH
Frank

CoaxCt wrote:
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?

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" wrote in message
...
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?

Thanks

Thanks for the quick reply. I will try this.