View Single Post
  #9   Report Post  
Rowan Drummond
 
Posts: n/a
Default 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