Which function/s should I use?
Very nice - that did the trick!
First time ever using the index function. Thank you.
A follow up though ~~ what if I wanted to show the top 3? Instead of just
the top one.
I know, you just answered my conundrum flawlessly :) Now though I'm
thinking I may be able to step this up a notch.
"T. Valko" wrote:
Try this:
=INDEX(A1:A27,MATCH(MAX(B1:B27),B1:B27,0))
--
Biff
Microsoft Excel MVP
"Emil" wrote in message
...
a1:a27 = name
b1:b27 = value
How can i find the highest value in column b and place it's corresponding
name into cell c1?
I realize this is likely a basic question, but I'm somewhat new to excel
and
appreciate any help. Thanks in advance, Emil.
|