How to get text
Try something like this:
With your posted data in A1:B4
This formula returns the name associated with the hight sco
=INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0))
Is that something you can work with?
***********
Regards,
Ron
XL2003, WinXP
"Bob" wrote:
I am not sure if anybody asked this question and I am sorry if I am repeting
it but i really need help. I made a chart with column A with names and Column
B with numbers. Now at the end I am trying to have in Column A the person
with the highest number only to be shown.
For Example,
A B
John 12
Sarah 3
Isabel 55
Caroline 33
Highest score has: Isabel
Please write in details I tried if and but it gives me #value I am messing a
lot somewhere
Thank you all so much for you time and help
|