Is there a way to VBA coding to detect and replace "Fuzzy" duplicates and typos with the text of the 1st match occurrence?

LydiaA

New Member
Joined
Nov 13, 2020
Messages
3
Office Version
  1. 2010
Platform
  1. Windows
Essentially I have a list of customer names and products sold, the issue is that the data source uses manually input Customer Names which often results in slight variances (typos, middle initials excluded/included, etc) This makes finding a true count of total products sold to each customer impossible. I am looking for a way to find and replace the near duplicates with their 1st near duplicate occurrence in an adjacent column so that I can use that new name column to determine the count of total customers. Please see the example below...

A​
B​
C​
D​
E​
DateMonthNameNew NameProduct
9/18/2020September360 THRIFT 3 LLC361 THRIFT 3 LLCReferred Merchant Services
10/7/2020October360 THRIFT LLC - missing a "3"362 THRIFT 3 LLCOther Products
9/17/2020SeptemberA & R NATURELLES, INC.A & R NATURELLES, INC.Business DDA
9/17/2020SeptemberA & R NATURELLES, INC - missing the "." after INCA & R NATURELLES, INC.Business DDA
10/27/2020OctoberA NATIONAL DELIVERER OF EVERYTHING LLC A NATIONAL DELIVERER OF EVERYTHING LLCOther Products
10/1/2020OctoberA NATIONAL DELIVERER OF EVERYTHING LLC D - added an extra "D"A NATIONAL DELIVERER OF EVERYTHING LLCBusiness Money Market
9/22/2020SeptemberA TO Z THERAPIES LLCA TO Z THERAPIES LLCOther Products
9/1/2020SeptemberA+ CREDIT AND DEBT HELP ASSOCIATIONA+ CREDIT AND DEBT HELP ASSOCIATIONOther Products
8/25/2020AugustA+ CREDIT AND DEBT HELP ASSOCIATIONA+ CREDIT AND DEBT HELP ASSOCIATIONBusiness DDA
8/25/2020AugustA& CREDIT AND DEBT HELP ASSOCIATION - typo, entered A"&" instead of A+A+ CREDIT AND DEBT HELP ASSOCIATIONBusiness Money Market
8/24/2020AugustAARON NICHOLAS AMARALAARON NICHOLAS AMARALRetail DDA
10/29/2020OctoberAARON R VEGAAARON R VEGARetail DDA
8/7/2020AugustAARON VEGA - missing "R"AARON R VEGARetail DDA

Using column C in the above data set, my Customer count totals: 12 unique customers
Whereas using the column D it totals: 8 unique customers (which is the correct total)

Unfortunately I do not have the Ablebits add-in to detect fuzzy duplicates etc
Is there a VBA code that can populate column D with the 1st occurrence of a near duplicate from column C?

Thank you kindly! :)
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

ExcelGzh

Board Regular
Joined
Mar 29, 2020
Messages
130
Office Version
  1. 365
Platform
  1. Windows
If you enter this search term "excel 365 vba fuzzy match" into your favourite search engine you should find something that suits your needs.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,465
Messages
5,624,894
Members
416,064
Latest member
PaulBr2

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