How show differences and count between 2 columns of text???

[pcumming]

Have Excel 2003. Need some help from you kind more experienced folks.
I have done some research but just have not found exactly what I am looking for.

I have a list of email addresses in column a
List of email addresses in column b.

** I would like a formula that will take all the values in column A and compare it to the entire list of entries in column B.
Would like it to show in Column C any entries in Column A that ARE NOT in the entire column B.

*Would like it to repeat for entries that are in Column B, but not in Column A and show in D.

*Then would like a count of the differences for each column (that is pretty easy).

It needs to look at the entire list of entries in the column as these will be email addresses. We want to know what is missing from Column A that is not in Column B and what is missing from B that is not in A.

Thanks for any help....

Sincerely
Peter

 

[Useful]

Hello!
use =VLOOKUP(A1;B:B;1;0) for colunm C
use =VLOOKUP(B1;A:A;1;0) for column D

 

[pcumming]

Hello!
use =VLOOKUP(A1;B:B;1;0) for colunm C
use =VLOOKUP(B1;A:A;1;0) for column D

**Thanks very much. That did indeed work.
I tried this as well: =IF(COUNTIF(A:A,B2)>0,"","B is not in A")

-Is there a way for the vlookup to display the actual cell value that is missing from the entire other column ?????

Thanks
Peter

 

[AhoyNC]

This link maybe of interest on how to extract missing items.

http://www.youtube.com/watch?v=0Ns2_2v7E0c&feature=plcp