Excel 2003 fuzzy search for duplicate.

A

Asha

Hello everyone,

does anyone know of an application or vb code that can be
used to search in two worksheets (like VLOOKUP) on
similar matches using fuzzy logic? For example, if on
one sheet I have I.B.M and the other IBM or James Smith
on one and Jim Smith on the other, is there anyway of
giving confidence codes to the match?

Thanks very much for your help,
 
E

Ed Ferrero

Hi Asha,

Look at soundex codes as explained by John Walkenbach
http://www.j-walk.com/SS/excel/tips/tip77.htm

You can use the SOUNDEX function as a worksheet formula, and then use
VLOOKUP on that.

In your example, both James Smith and Jim Smith have the same soundex code
of J525.

You do need to be cautious when using this. For instance, I.B.M. and IBM
both have the same soundex code (I150), but so does IBN, which you may not
want to equate to the others.

Ed Ferrero
www.edferrero.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using fuzzy logic in excel 7
Need a function to match unidentical strings 0
Testing a string againsts a list of strings 2
Duplicate detection (looking for code) 9
How do I match using partial or approximate values? 3
trouble with (complicated) vlookup searching another workbook 2
multiple search results 3
Fuzzy search using sql 9

Top