Actually, I hadn't received a response yet and you seemed to know what you
were doing, given your response to what seems like a similar problem. My
apologies for the confusion, though.


"Ragdyer" wrote in message
...
That appears to clear up the "mud", and it also appears you gave him what
he
asked for!

Never too sure when OPs repost simply because they don't know how to keep
track and find their own posts after time buries them deeper and deeper
within the groups.

Your link here should solve even that supposition.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T. Valko" wrote in message
...
http://tinyurl.com/2mtl7b

Biff

"Ragdyer" wrote in message
...
I don't follow exactly what you're looking for.

What do you mean by:
<<<"with substantially varying numbers of rows between them"

Does that mean that the 2 symbols are *not* in the same row in both
columns?

What are you looking to do with these *same* symbols?
Do you want to count them ... or what?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-



"Manfred" wrote in message
...
RD,

Can you recommend a matching formula that would search for the same
stock
symbols in two columns with substantially varying numbers of rows
between
them, and list only these symbols in a separate 3rd column?

Any response appreciated.


"RagDyeR" wrote in message
...
Try this:

=INDEX(A:A,MATCH(MAX(K:K),K:K,0))
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"harvey1649" wrote in message
...
I want to look up the largest number in coloum K and return the
value
in
Coloum A that is in the same row that the largest number in Coloum K
is.