Display top rankings

[Guest]

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

 

[T. Valko]

With employee names in the range A1:A10 and their rank in B1:B10...

=INDEX(A1:A10,MATCH(1,B1:B10,0))

 

[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

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,D24,0))
=INDEX(A2:A4,MATCH(1,E2:E4,0))
etc
etc

 

[Guest]

THANK YOU GENTLEMAN, YOU GUYS ARE AWESOME

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,D24,0))
=INDEX(A2:A4,MATCH(1,E2:E4,0))
etc
etc