Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing to rank values
I have a 15 employees that are measured in 7 different metrics of their job
function. I need to be able to determine who is performing the best and worst in each metric and rank my employees. In some of these metrics the largest value would be considered better while in other metrics the smaller value would be the best. Any suggestions? Ex. Employee Qual Timely Commit Abs a 2.75 412 97.56% 3.28% b 4.25 510 95.40% 0% c 3.25 380 96.78% 1.8% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average values for a given rank | Excel Discussion (Misc queries) | |||
Needing to return multiple values from single column | Excel Worksheet Functions | |||
RANK with 0 values | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) | |||
RANK bug: same values get different ranks | Excel Worksheet Functions |