comparing data - find data in 2 columns

[empire]

I have a list of item codes in column A and a list of item codes i
column F and I need to know which item codes appear in both columns
Can someone please tell me the best way to get a list of the item code
that appear in BOTH of the columns.

Thank

 

[Frank Kabel]

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

 

[empire]

Thank you very much - that worked perfectly