How do I compare names in two spreadsheets and then pull out only.

[A @ Baker]

How do I compare two spreadsheets of names and pull out only the names that
differ from each list?

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther