Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting duplicate data from two lists
Hi,
I have two lists, consisting of customer ids in the form 00-00-00 ( using custom format). The first list consists of 15,000 ids and the second one contains 500 id's. I would like to create a third column that would consist of id's that are in both lists. Any help would be greatly appreciated, nikf |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting duplicate data from two lists
Next to either list put in the formula
=if(Countif(Sheet2!$A$1:$A$15000,A1)0,A1,"") then drag fill down alongside list (in the example, the list of 500 ID's). -- Regards, Tom Ogilvy "nikf" wrote in message om... Hi, I have two lists, consisting of customer ids in the form 00-00-00 ( using custom format). The first list consists of 15,000 ids and the second one contains 500 id's. I would like to create a third column that would consist of id's that are in both lists. Any help would be greatly appreciated, nikf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data for address lists | Excel Worksheet Functions | |||
subtracting (extracting non-duplicate items)HELP!! | Excel Worksheet Functions | |||
Extracting the Duplicate Records | Excel Discussion (Misc queries) | |||
Comparing two lists and extracting data from one to another | Excel Worksheet Functions | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) |