| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I compare 2 lists and show duplicates as a new list?
I have 2 lists of several part numbers. I need to compare both lists and
extract all the duplicate numbers, copy them and place them in a new list. Does anyone have a macro that can do this task that they are willing to share? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I compare 2 lists and show duplicates as a new list?
Hi AnaBannana
One way is to use Advanced filter And copy the filtered list to another place See http://www.contextures.com/xladvfilter02.html#Match -- Regards Ron de Bruin http://www.rondebruin.nl "AnaBannana" wrote in message ... I have 2 lists of several part numbers. I need to compare both lists and extract all the duplicate numbers, copy them and place them in a new list. Does anyone have a macro that can do this task that they are willing to share? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I compare 2 lists and show duplicates as a new list?
Thanks - but my lists contain thousands of numbers, and a filter is not going
to provide me with a workable list. I need to copy any part numbers that are duplicated in 2 workbooks and place them in another, thereby creating another workbook or sheet. "Ron de Bruin" wrote: Hi AnaBannana One way is to use Advanced filter And copy the filtered list to another place See http://www.contextures.com/xladvfilter02.html#Match -- Regards Ron de Bruin http://www.rondebruin.nl "AnaBannana" wrote in message ... I have 2 lists of several part numbers. I need to compare both lists and extract all the duplicate numbers, copy them and place them in a new list. Does anyone have a macro that can do this task that they are willing to share? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I compare 2 lists and show duplicates as a new list?
Hi
duplicated in 2 workbooks Try http://www.cpearson.com/excel/download.htm Look for the Compare add-in -- Regards Ron de Bruin http://www.rondebruin.nl "AnaBannana" wrote in message ... Thanks - but my lists contain thousands of numbers, and a filter is not going to provide me with a workable list. I need to copy any part numbers that are duplicated in 2 workbooks and place them in another, thereby creating another workbook or sheet. "Ron de Bruin" wrote: Hi AnaBannana One way is to use Advanced filter And copy the filtered list to another place See http://www.contextures.com/xladvfilter02.html#Match -- Regards Ron de Bruin http://www.rondebruin.nl "AnaBannana" wrote in message ... I have 2 lists of several part numbers. I need to compare both lists and extract all the duplicate numbers, copy them and place them in a new list. Does anyone have a macro that can do this task that they are willing to share? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate 3 lists with duplicates into one list | Excel Worksheet Functions | |||
| My pivot table field list show duplicates | Excel Discussion (Misc queries) | |||
| Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
| Compare List and Show Mismatched | Excel Worksheet Functions | |||
| Can I compare 2 lists to combine duplicate entries in new list? | Excel Worksheet Functions | |||
Linear Mode
