Compare Text in 2 worksheets where verbiage is slightly different

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

Guest

I have 2 lists of clients, which may contain common clients, but the company
names may be written differently, such as Baptist Health System and Baptist
Medical Center. List A is the standard list that I wish to tie my records in
List B to. List A contains 6,000 records and B has 3,000. I would like
generate a list of 'possible matches for review manually'. Sorta like an
automated "Find All" in List A for each name in List B. Any ideas? Thanks,
Anne
 
Data > Filter > AutoFilter > click the arrow at the top of your column of
interest, then Custom > Begins with > and insert your first 3 or 4
characters > OK......refine as necessary.

Vaya con Dios,
Chuck, CABGx3
 
Well, you know, that is what I've been doing. But it takes forever to check
them all this way. I was hoping for a variation of LOOKUP or MATCH that
would point me directly to the record, then I was going to modify the formula
to automatically pull data from another cell. I'm trying to set a key in
List B that matches the one in List A. Thanks, though. Anne
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare text in 2 different files 2
Compare two datasets and extract unique records from each 3
Comparing text within cells in two columns 2
Compare text in 2 separate spreadsheets, when match found display 3
Compare 2 Worksheets and return differences in a third. 4
Access Access - Is it possible to repeat fields in a form? 1
Compare 2 worksheets 1
Comparing 2 worksheets in Excel 2007 1

Back
Top