Listing Common Symbols Of 2 Columns

  • Thread starter Thread starter Manfred
  • Start date Start date
M

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?
 
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
 
Back
Top