Listing Common Symbols Of 2 Columns

[Manfred]

I have two columns of symbols that may or may not contain one or more of the
same symbols. Is it possible for Excel to list the symbols that are carried
in both columns in a separate column? If so, can someone provide the
formula to perform this task?

 

[Biff]

Hi!

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

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

Copy down until you get #NUM! errors meaning all matches have been
extracted.

Biff

 

[Manfred]

Biff,

Thank you for taking the time to answer this question.

 

[Biff]

You're welcome.

Biff

Biff,

Thank you for taking the time to answer this question.