View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Asha Asha is offline
external usenet poster
 
Posts: 12
Default Excel 2003 fuzzy search for duplicate.

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,