Find Duplicate Data in Two Lists
 

Hey everyone...

I have somewhat of an emergency help request. I need a way to "look
at" two columns of data, and identify any duplicates. The columns of
data are of different lengths, and any duplicates will more than likely
appear in different rows as well.

I have both columns sorted from smallest to largest. An example of the
data is listed below:

A1 B1
00100300 00100300
00100900 00100400
00101600 00100800
00101700 00100900
00102000 00101200
00102200 00101600
00102900 00101900
00103200 00102000
00103300 00102300

So, in this example set, you will see that 00100300, 00100900 and
00102000 appear in both lists. I am not really sure the best approach
to take with this, so let me tell you what I need for an output for the
client:

1) Column A1 will have the least amount of data. I first need to find
all the codes in A1 that appear in B1. This will create my first set
of desired results. I am not sure the easiest way to "flag" these
schools.

2) The leftover data in column A1 will be codes NOT listed in B1, and
the leftover data in column B1 will be codes NOT listed in A1... So
this being true, those would be simple enough to identify.

Any help on this small problem would be greatly appreciated... Thanks
to everyone in advance!!

Stacy

Find Duplicate Data in Two Lists
 

Take a look at

http://cpearson.com/excel/duplicat.htm

In article .com,
"stacy" wrote:

Hey everyone...

I have somewhat of an emergency help request. I need a way to "look
at" two columns of data, and identify any duplicates. The columns of
data are of different lengths, and any duplicates will more than likely
appear in different rows as well.

I have both columns sorted from smallest to largest. An example of the
data is listed below:

A1 B1
00100300 00100300
00100900 00100400
00101600 00100800
00101700 00100900
00102000 00101200
00102200 00101600
00102900 00101900
00103200 00102000
00103300 00102300

So, in this example set, you will see that 00100300, 00100900 and
00102000 appear in both lists. I am not really sure the best approach
to take with this, so let me tell you what I need for an output for the
client:

1) Column A1 will have the least amount of data. I first need to find
all the codes in A1 that appear in B1. This will create my first set
of desired results. I am not sure the easiest way to "flag" these
schools.

2) The leftover data in column A1 will be codes NOT listed in B1, and
the leftover data in column B1 will be codes NOT listed in A1... So
this being true, those would be simple enough to identify.

Any help on this small problem would be greatly appreciated... Thanks
to everyone in advance!!

Stacy