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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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,170,932
Messages
5,872,779
Members
432,945
Latest member
eddyevad

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