One way

=IF(ISNUMBER(MATCH(B1,$A$1:$A$20,0)),B1,"")

copy down, if there are duplicate entries use dataadvanced filter to create
a distinct list

--
Regards,

Peo Sjoblom

(No private emails please)


"ruby2sdy" wrote in message
oups.com...
Hi

Can anyone please help me compare two columns of text to come up with a
list of items that are in both lists

Many thanks