Finding/Listing Symbols from 2 Columns

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

Manfred

I thought I knew how to perform the following simple function, but I must be
missing something basic.

The problem: I am assembling a spreadsheet consisting simply off 2 columns
of symbols. The two columns may or may not have matching symbols.

The question: Is there a formula what will search through both columns and
list symbols only that appear in both columns? If so, can somebody please
list the steps?

Thank you for any response.
 
With
A1:A10 containing one set of symbols
B1:B10 containing another set of symbols, including some matches from the
1st set.

Try this ARRAY FORMULA:

D1:
=INDEX($A$1:$A$10,SMALL(IF(COUNTIF($B$1:$B$10,$A$1:$A$10),ROW($A$1:$A$10)),ROWS(D$1:D1)))

Copy D1 and paste it into D2 and down as far as you need

Note: For array formulas, hold down [Ctrl] [Shift] when you press [Enter],
instead of just pressing [Enter].

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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

Clarification: Finding/Listing Symbols Found in 2 Columns 6
Finding Matching Symbols in 2 Columns 5
Scoring/Ranking 2 Columns of Stock Symbols 7
Formula to search for given term, and if not found in column to add it to list 3
Text Formula Question 6
Listing Common Symbols Of 2 Columns 3
match or vlookup functions? 1
Extract information from the list 3

Back
Top