| 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) | |||
Linear Mode
