how do i see if entries in one column are in another column?

[mpt1]

I have two unequal columns of data. How do I see if entries from column A
are also in comun B? Thanks

 

[JE McGimpsey]

Take a look at

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