Extracting values common to two lists

[L.ew Ershler]

Can anyone give me a formula to extract common values in two lists (columns)?
I've tried and can't seem to make it work.

Thanks

Lew

 

[J.E. McGimpsey]

Can anyone give me a formula to extract common values in two lists (columns)?
I've tried and can't seem to make it work.

Take a look here:

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