View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AnaBannana AnaBannana is offline
external usenet poster
 
Posts: 2
Default 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?