D
Dino
I need a formula to display the name of the person associated with having the
highest percentage in a competition.
highest percentage in a competition.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
="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
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
T
T. Valko
You're welcome. Thanks for the feedback!