Ok, I see that Ron answered your other post. The solution he provided should
work. What kind of problem are you having?

Here's a tweaked version of Ron's formula that adds an error trap and
includes an "enhanced offset mechanism" (which is where a lot of people have
problems with this type of formula). This is still an array** formula. It's
comparing column A to column B:

Data starting in row 2.

=IF(ROWS($1:1)<=COUNT(1/(ISNUMBER(MATCH(A$2:A$10,B$2:B$10,0)))),INDEX(A$2: A$10,SMALL(IF(COUNTIF(B$2:B$10,A$2:A$10),ROW(A$2:A $10)-MIN(ROW(A$2:A$10))+1),ROWS($1:1))),"")

Copy down until you get blanks.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Manfred" wrote in message
...
Biff,

Thanks greatly for responding. Both columns, consisting of stock symbols,
may have as many as 250 rows, but neither is likely to have the same
number of rows, and both will vary with each computation effort.



"T. Valko" wrote in message
...
Define symbols. Do you mean stock ticker symbols?

Are both columns the same length? You only need to check the shortest
column. How many rows does the shortest column contain?

Biff

"Manfred" wrote in message
...
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 of 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 that appear in BOTH columns, LISTING these symbols in a
separate third column?

Thank you for any response.