Checking for duplicates w/different iterations

BoilerBob

Board Regular
Joined
Apr 10, 2006
Messages
98
I searched the board and found useful tools for checking for duplicates, but have a challenge when data is coming from two diffent sources. I would like "AM BEST", "A.M. Best" and "A. M. Best" to show up as duplicates, but could not find an elegant way.

My current solution is to replace (CTRL-H) all periods, commas, and spaces with null.

Any more insightful solutions?
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
why dont you post sample of your data so that everybody could have an idea as to where would you want to evaluate your duplicates records?
 

BoilerBob

Board Regular
Joined
Apr 10, 2006
Messages
98
Sample would be a database with current clients such as

Abbot Labs
Abbey Road
ABC Corp
A. M. Best
Aramark

....

And a prospect list with

Abbot Laboratory
Anheuser Busch
A.B.C. Corp
A.M. Best
.....

I would like to see if the prospects are in our current list. In the sample above, Anheuser Busch would be the only 'new' client to add to our list. A typical lookup would have all the companies not being duplicates because of slight variations.
 

Forum statistics

Threads
1,136,991
Messages
5,679,014
Members
419,799
Latest member
APInfa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top