Seperating Data From Lists

[JF]

My mate sends me lists of mp3 files every so often. But he doesn't keep new
ones seperate. How can I tell excel to compare both lists and put the
discrepancies into a new column.

Cheers

 

[JE McGimpsey]

See

http://cpearson.com/excel/duplicat.htm

 

[JF]

See

http://cpearson.com/excel/duplicat.htm

Thanks