display person's name with highest percentage in particular cell

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

I need a formula to display the name of the person associated with having the
highest percentage in a competition.
 
If name is in A1 and percentage in B1 then in C1 use something like
="A1" & " has the highest percentage which is " & B1
 
...........A..........B
1.......Jill.........30
2.......Tom......27
3.......Bill........99
4.......Sue.......86
5.......Lisa......44

=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0))

Result = Bill
 
Thanks, that was perfect. I appreciate it.

T. Valko said:
...........A..........B
1.......Jill.........30
2.......Tom......27
3.......Bill........99
4.......Sue.......86
5.......Lisa......44

=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,0))

Result = Bill
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DISPLAY PERSON'S NAME WITH HIGHEST PERCENTAGE OF SALES 4
highest value between rows 7
Formula for increasing a result to the next highest 1000 2
Percentage Formula 3
Sort highest by name 5
Access Test if value is less than percent 0
Percentage 1
Rank and Sort 15

Back
Top