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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to strip an individual symbol from each row in a column 1
vba macro that allows insertion of symbols at cursor 0
2007 Pvt Group/Ungroup symbols 3
Help with formula 1
What is blue symbol bottom right corner of cell 2
Stock Symbol Column comparison 5
Excel Count If Formula Question 1
Insert symbol as a header for a column 1

Back
Top