Thread: How do I compare 2 lists and show duplicates as a new list?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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?


Reply With QuoteReply With Quote