Searching for a particlar value and matching to a name..

  • Thread starter Thread starter spezialize
  • Start date Start date
S

spezialize

• Add a column for winner that displays the name of the person with
highest % goal reached.

I have several columsn with names.. and then more columns with
numbers.. once i get the max number i wanna see what name corresponds
with that number..
 
didnt work for me... let me try to explain better what I have since it
wont let me post my excel file..

I have a column with Names... some columns after with quarterly
numbers, a column which adds all those sales(total column), a goal
column, and then a column which calculates the percent of the goal the
person has reached. I need a column which will display the name of the
person with the highest perecentage goal, and then have that number
show up.
 
I also am having trouble creating a vlookup table... ive rea
documentation but it isnt flying with me..

• Add a column for “Ranking” based on percent of goal reached using
vlookup table
create the table where those selling over 100% of target goal ge
Excellent, those from 90-100% get Good, from 75-89 get Fair and an
below 75% get Monito
 
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)

Is this what you were wanting?
Regards
Rowan
 
You're welcome. I also replied to your question regarding the ranking
but it is not showing up on my newsreader. Repeated here:

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
 
Back
Top