Okay, that would work, but my lists are too big. Excel starts to process it and says "Calculating Cells: 5% complete", and then it hangs, and I have to kill it and start over. Any ideas on that
   
    ----- Frank Kabel wrote: ----
   
    Hi Scot
    as a starting point have a look a
    http://www.cpearson.com/excel/duplicat.htm#ExtractingCommo
    http://www.cpearson.com/excel/duplicat.htm#InOneNotOthe
   
    -
    Regard
    Frank Kabe
    Frankfurt, German
   
   
    Scott wrote
    > Hi
    >    I have two lists, one is shorter than the other. I need to make
    > third list that contains only items that are in both lists. Let's sa
    > that column A is my short list (about 2,000 entries), column B is m
    > long list (about 20,000 entries), and I'm going to make column C
    > list only of items that are in both lists. I don't even know where t
    > start. Any ideas
    >> Also, the entries in column A may change depending on user input, s
    > of course the new column C needs to reflect the change as well
    > Column B can also change, but usually doesn't
    >> Thanks in advance
    > Scot