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...
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!
A | B | C | D | E |
Date | Month | Name | New Name | Product |
9/18/2020 | September | 360 THRIFT 3 LLC | 361 THRIFT 3 LLC | Referred Merchant Services |
10/7/2020 | October | 360 THRIFT LLC - missing a "3" | 362 THRIFT 3 LLC | Other Products |
9/17/2020 | September | A & R NATURELLES, INC. | A & R NATURELLES, INC. | Business DDA |
9/17/2020 | September | A & R NATURELLES, INC - missing the "." after INC | A & R NATURELLES, INC. | Business DDA |
10/27/2020 | October | A NATIONAL DELIVERER OF EVERYTHING LLC | A NATIONAL DELIVERER OF EVERYTHING LLC | Other Products |
10/1/2020 | October | A NATIONAL DELIVERER OF EVERYTHING LLC D - added an extra "D" | A NATIONAL DELIVERER OF EVERYTHING LLC | Business Money Market |
9/22/2020 | September | A TO Z THERAPIES LLC | A TO Z THERAPIES LLC | Other Products |
9/1/2020 | September | A+ CREDIT AND DEBT HELP ASSOCIATION | A+ CREDIT AND DEBT HELP ASSOCIATION | Other Products |
8/25/2020 | August | A+ CREDIT AND DEBT HELP ASSOCIATION | A+ CREDIT AND DEBT HELP ASSOCIATION | Business DDA |
8/25/2020 | August | A& CREDIT AND DEBT HELP ASSOCIATION - typo, entered A"&" instead of A+ | A+ CREDIT AND DEBT HELP ASSOCIATION | Business Money Market |
8/24/2020 | August | AARON NICHOLAS AMARAL | AARON NICHOLAS AMARAL | Retail DDA |
10/29/2020 | October | AARON R VEGA | AARON R VEGA | Retail DDA |
8/7/2020 | August | AARON VEGA - missing "R" | AARON R VEGA | Retail 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!