Biff,

Thank you very much for responding. My apologies, but I can't find the
answer or formula that Ron gave. Sorry if this is a stupid question, but
concerning the formula that you generously provide, are the column/rows to
remain as e.g. A$2:A$10 and B$2:B$10 even if I've got, say, 200 rows in
column A and 40 rows in column B?

Also, are array formulae copied from row to row in the same manner as
non-array formulae?

Thank you for any response.


"T. Valko" wrote in message
...
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.