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

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

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

.. 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,R OWS($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
--
Max
Singapore
---
"Anna De Geer" wrote:
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 extract 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