Comparing 2 Lists

[Scott]

Hi
I have two lists, one is shorter than the other. I need to make a third list that contains only items that are in both lists. Let's say that column A is my short list (about 2,000 entries), column B is my long list (about 20,000 entries), and I'm going to make column C a list only of items that are in both lists. I don't even know where to start. Any ideas

Also, the entries in column A may change depending on user input, so 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
Scott

 

[Frank Kabel]

Hi Scott
as a starting point have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Scott]

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