| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display top rankings
THANK YOU GENTLEMAN, YOU GUYS ARE AWESOME
"JW" wrote: On Oct 10, 12:10 am, THFish wrote: 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,D2:D4,0)) =INDEX(A2:A4,MATCH(1,E2:E4,0)) etc etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Rankings function | Excel Worksheet Functions | |||
| How Do I Combine Rankings for Multiple Categories? | Excel Discussion (Misc queries) | |||
| assigning points to rankings | Excel Worksheet Functions | |||
| Creating a Rankings Table | Excel Worksheet Functions | |||
| Unique Rankings | Excel Discussion (Misc queries) | |||
Threaded Mode
