Hi!

One way:

Assume the lists are in the range A1:B10

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(A$1:A$10,SMALL(IF(COUNTIF(B$1:B$10,A$1:A$10 ),(ROW(A$1:A$10)-ROW(A$1))+1),ROW(1:1)))

Copy down until you get #NUM! errors meaning the data has been exhausted.

Biff

"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