Two lists and how do I extract contents in one from the other?

  • Thread starter Thread starter Anna De Geer
  • Start date Start date
A

Anna De Geer

I have two e-mail lists in excel, A and B. List A is a small list and List B
is much longer and includes list A. How can I exctract the e-mails from list
B that are in list A? A short version is: how do I do B minus A? I use Office
2003.
/Anna
 
.. how do I do B minus A?
Here's one way that should deliver the expected results
Assume source data running in row2 down
In C2: =IF(B2="","",IF(COUNTIF(A:A,B2),"",ROW()))
In D2: =IF(ROWS($1:1)>COUNT(C:C),"",INDEX(B:B,SMALL(C:C,ROWS($1:1))))
Copy C2:D2 down to the last row of data in col B. Hide away/minimize col C
Col D will return the required results all neatly packed at the top
Success? hit the YES below
 
Back
Top