ExcelBanter - Comparing 2 Customer Lists to Identify Shared Customers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Comparing 2 Customer Lists to Identify Shared Customers (https://www.excelbanter.com/excel-worksheet-functions/10052-comparing-2-customer-lists-identify-shared-customers.html)

carl

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 ?

Bernie Deitrick

Carl,

See the thread at

http://groups-beta.google.com/group/...86dfc0974048ac

Harlan Grove shows some techniques for matching slightly mismatched text.

HTH,
Bernie
MS Excel MVP

"carl" wrote in message
...
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 ?

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 ?

"Bernie Deitrick" wrote:

Carl,

See the thread at

http://groups-beta.google.com/group/...86dfc0974048ac

Harlan Grove shows some techniques for matching slightly mismatched text.

HTH,
Bernie
MS Excel MVP

"carl" wrote in message
...
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 ?

All times are GMT +1. The time now is 10:30 AM.