This was most helpful and simple to do. Most of the other aswers are for
very seasoned excel users and difficult to understand. This worked for me!
Thanks Pete

"Pete" wrote:

Assuming you have one list in column A (the longer one), and the other
list in column B (the shorter one), both starting on row 2 with a
header row on row 1, enter this formula in cell C2:

=IF(ISNA(MATCH(B2,A$2:A$250,0)),"",B2)

This assumes the first list in column A occupies A2 to A250 - adjust to
suit. Copy this formula down for as many entries as there are in column
B (double-click the fill handle). This will list the common entries and
will return a blank if there is no match - you could fix the values
with paste special, then sort the items in this list so that the blanks
drop to the bottom.

Hope this helps.

Pete