View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default Comparing 2 Customer Lists to Identify Shared Customers

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) a

Banc Two
Bear Wagner
Bear, Stearns

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