Display top rankings

T

THFish

If I have a spread sheet showing employees with their metrics and I have each
metric ranked, how do I pull the top ranked employee's name out of that
spread sheet and display it in a different place in that work book.

ex.
employee qual timely abs comm
a 1 4.25 15 510 4 2.5 3 96.4
b 5 3.83 2 330 1 0 10 95.8
c 10 2.9 1 310 15 26 1 98.0
 
J

JW

If I have a spread sheet showing employees with their metrics and I have each
metric ranked, how do I pull the top ranked employee's name out of that
spread sheet and display it in a different place in that work book.

ex.
employee qual timely abs comm
a 1 4.25 15 510 4 2.5 3 96.4
b 5 3.83 2 330 1 0 10 95.8
c 10 2.9 1 310 15 26 1 98.0
Click to expand...

Index/Match. Try something like this. This is assuming that your
employees are in column A and the rank is in column B.
=INDEX(A2:A4,MATCH(1,B2:B4,0))

You can then use this type of formula to return the ranks for all of
the information.
=INDEX(A2:A4,MATCH(1,D2:D4,0))
=INDEX(A2:A4,MATCH(1,E2:E4,0))
etc
etc
 
T

THFish

THANK YOU GENTLEMAN, YOU GUYS ARE AWESOME

JW said:
Index/Match. Try something like this. This is assuming that your
employees are in column A and the rank is in column B.
=INDEX(A2:A4,MATCH(1,B2:B4,0))

You can then use this type of formula to return the ranks for all of
the information.
=INDEX(A2:A4,MATCH(1,D2:D4,0))
=INDEX(A2:A4,MATCH(1,E2:E4,0))
etc
etc
Click to expand...
 
Top