I'm using the Soundex algorithm (free on the Internet at http://allenbrowne.com/vba-Soundex.html) which does a phoenitic "fuzzy" comparison of names. Unfortunately, with this method, multiple distinct names produce the same result.
Examples of which I want to match are
ABC, INC. ABC CO INC
aaa bbb ccc aaa bbb
x corp x corporation
Does anyone have any ideas? There are too many rows to compare by inspection.
Thank you in advance for your responses.
Examples of which I want to match are
ABC, INC. ABC CO INC
aaa bbb ccc aaa bbb
x corp x corporation
Does anyone have any ideas? There are too many rows to compare by inspection.
Thank you in advance for your responses.