Thread: How to get text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 698
Default 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