Ranking employees based on Multiple Criteria

[harri718]

I need help on unique ranking based on multiple criteria.

I've been asked to rank 10 employees based on the following criteria: BA %, FA %, Outstanding FA% and Uncontacted %.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]Name [/TD]
[TD="align: center"] BA %[/TD]
[TD]

​

[TABLE="width: 377"]
<tbody>[TR]
[TD="align: center"]FA %[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]Outstanding FA%[/TD]
[TD="align: center"]Uncontacted %[/TD]
[/TR]
</tbody>[/TABLE]


How do I go about ranking the employees based on the highest number of sales, highest completion rate with the lowest absenteeism rate? Employee with rank 1 should have the highest number of sales, highest BA % andFA %rate and the lowest Outstanding rate and Uncontacted rate among the other 9 employees.

Hope that makes sense!

Thanks in advance!

****** id="cke_pastebin" style="position: absolute; top: 81.3333px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 377"]
<tbody>[TR]
[TD] FA %[/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[rpaulson]

Add a column to rank each field: Then add the ranks together for a total: then rank the total. Example if six fields then a perfect score would be 6 (Rank of 1 for each field).