I need some VBA that does a fuzzy match of text. I have a list of fax numbers that can be appended by various people in my office. The list is getting huge and I just know there are duplicates in there. It’s easy enough to sort on the fax number and see if there are duplicates, but that doesn’t get them all.
I want to go through the other two columns, Contact Name and Company, and compare them. I want to identify where someone typed in ABC, Inc. and someone else typed in just ABC.
I think it will have to be some sort of scoring system, where the characters are compared and a score is assigned. Scores above a certain number will be considered duplicates.
If you’ve heard of this already being done or you are inclined to tackle this yourself, post a comment. Thanks.