Prev: Query website from spreadsheet
Next: Comparing two spreadsheets to analyze changes
From: Al Franz on 18 Jul 2008 14:12
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.


From: JLGWhiz on 18 Jul 2008 14:54
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.
>
>
>
From: Chad on 18 Jul 2008 15:29
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" <albert(a)nospam.netmation.com> wrote in message
news:ujskNHQ6IHA.2260(a)TK2MSFTNGP03.phx.gbl...
> 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.
>


 | 
Pages: 1
Prev: Query website from spreadsheet
Next: Comparing two spreadsheets to analyze changes