Comparing 2 Customer Lists to Identify Shared Customers

[carl]

I have two customer lists. Each lists may contain the same customer but
spelled differently. I am trying to identify the customers that appear on
both list. My 2 lists look something like this:

List1

Banc Two
Bear Wagner
Bear, Stearns
Calyon Financial

List2

Bank Two
Bear, Wagner
Bear Stearns

The customers that appear on both lists (using list 1 names) are:

Banc Two
Bear Wagner
Bear, Stearns

Is it possible to create this list of customers that appear on both list 1
and list 2 ?

 

[Bernie Deitrick]

Carl,

See the thread at

http://groups-beta.google.com/group...3e59569022b/ce86dfc0974048ac#ce86dfc0974048ac

Harlan Grove shows some techniques for matching slightly mismatched text.

HTH,
Bernie
MS Excel MVP

 

[carl]

thanks for the link. i went there and tried to get the soundex code to run -
could not. what do i need to do to try this code ?