Similar Cell Data Comparison?

[Al Franz]

Is there any function or add-on that can allow me to compare two cells and
provide some type of similarity score? Would like to determine matches such
as "John Smith" to "Johnny Smith Jr.", or "5006" to 50006" at to flag those
rows some how.

Thanks for any ideas.

 

[JLGWhiz]

Hi Al, I don't believe VBA is quite that smart yet. However, if you have
some commonality in the data such as using the first initial and last name
(J. Smith), you could probably write some code to search out those portions
of all names. You could also use the Like operator with wild cards to look
for partial data sets (*smit*). If there is a regular pattern, you can use
Left, Right or Mid functions to capture part of a data set for comparison.
But I don't know of a function that is smart enough to look variations and
typos.

 

[Chad]

For the numbers,
if you know the number is suspose to be a 4 digit number, then you can flag
any 5 numbers.