Searching for a particlar value and matching to a name..
You're welcome. I also replied to your question regarding the ranking
but it is not showing up on my newsreader. Repeated he
To get the name of the person with the highest percentage assume names
in A2:A5 and percentages in D2:D5
=INDEX($A$2:$A$5,MATCH(MAX($D$2:$D$5),$D$2:$D$5,0) ,1)
Note: if there is a tie this will give you the name of whoever is listed
first with the highest percentage.
To get the actual highest percentage simply =MAX($D$2:$D$5)
Regards
Rowan
spezialize wrote:
thank you :) very solid
|