Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and display duplicate data | Excel Discussion (Misc queries) | |||
Find Duplicate data | Excel Discussion (Misc queries) | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
Another question on how to find duplicate data | Excel Worksheet Functions | |||
Extracting duplicate data from two lists | Excel Programming |