display person's name with highest percentage in particular cell

D

Dino

I need a formula to display the name of the person associated with having the
highest percentage in a competition.
 
S

Sheeloo

If name is in A1 and percentage in B1 then in C1 use something like
="A1" & " has the highest percentage which is " & B1
 
T

T. Valko

...........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
 
D

Dino

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

Resource name inside resource sheet: per person, work per hours per week 0
DISPLAY PERSON'S NAME WITH HIGHEST PERCENTAGE OF SALES 3
Number range as a percentage 2
highest value between rows 7
Formula for increasing a result to the next highest 1000 2
Confusion over where user templates are stored in Word 1
how to return "summary" of all non-blank cells plus their headers 10
Second highest frequency 1

Top