View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
THFish THFish is offline
external usenet poster
 
Posts: 11
Default 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%