Let's say that your data is in A1:B4
To return "c" as the value that matches the max value, use this
=INDIRECT("A"&MATCH(MAX(B1:B4),B1:B4))
I'm sure there's a way to dynamically determine the "A" value, but this gets
you what you need..
"nicgendron" wrote
in message ...
Hi, all,
I have something like this :
a 1
b 4
c 5
d 3
I'm doing a max function in the number column and it returns me '5'
But, after that, I want to know the letter which corresponds to the max
number
How can I do that?
Thanks
Nic
--
nicgendron
------------------------------------------------------------------------
nicgendron's Profile:
http://www.excelforum.com/member.php...o&userid=25151
View this thread: http://www.excelforum.com/showthread...hreadid=386417