If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Compare addresses in two worksheets
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 |
#3
|
|||
|
|||
Compare addresses in two worksheets
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 |
#4
|
|||
|
|||
Compare addresses in two worksheets
Thanks for the quick reply. I will try this.
|
Thread Tools | |
Display Modes | |
|
|