Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar Cell Data Comparison?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar Cell Data Comparison?
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. "Al Franz" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar Cell Data Comparison?
For the numbers,
if you know the number is suspose to be a 4 digit number, then you can flag any 5 numbers. "Al Franz" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparison similar rows in Excel | Excel Discussion (Misc queries) | |||
Comparison between two similar strings | Excel Programming | |||
Complex comparison of Columns of Data: Extracting unique records after comparison on 4 levels | Excel Programming | |||
similar vs. exact comparison | Excel Discussion (Misc queries) | |||
Similar vs. Exact comparison | Excel Programming |