Fuzzy matching names in two columns

[jg77]

I'm trying to match user names from column A with user names from colum
B. The matches will not be exact however, they will be "fuzzy".

Column A contains user names inputted by the end users *shutter*

Column B contains user names from a HR database.

Problem is users do not input their names exactly as they appear in th
HR database. For instance, users like to abreviate "thomas" to tom
don't add their middle initial, and often times misspell their names.

Does someone know of a function/macro that can perform the fuzzy match
I tried DigDB but that didn't work.

Thanks in advance

 

[drabbacs]

Check out http://www.cpearson.com/excel/lookups.htm about
2/3 of the way down the page. Closest Match.

-----Original Message-----

I'm trying to match user names from column A with user names from column
B. The matches will not be exact however, they will be "fuzzy".

Column A contains user names inputted by the end users *shutter*

Column B contains user names from a HR database.

Problem is users do not input their names exactly as they appear in the
HR database. For instance, users like to abreviate "thomas" to tom,
don't add their middle initial, and often times misspell their names.

Does someone know of a function/macro that can perform the fuzzy match?
I tried DigDB but that didn't work.

Thanks in advance.


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[Jordon]

Why not use Data Validation to force users
to select their name from a list?

Jordon