Forum Discussion
Ranking employees performance from best to worst
Hi how can I rank these employees from best to worst in excel ?
Based on the data you have given< question is? what criteria do you think are the best peaked period for deliver?
If you can tell me, i use formula to calculate it?
If you can tell me, i use formula to calculate it?
Delivered order, Delivery time and acceptance rate
- Oh, iforget to add Acceptance rate as well as criteria ranking? let me redo for you
- Thanks will be waiting
tatto330 Done!
tatto330 Done!I used RankEQ Function and then ranked each 3 categories " by Best to Worst Ranking by Delivered orders" then > by Rank by Best to Worst Bad rated orders > by Best to worst Ranking Orders in peak hours*
Then, logically you need to sort by three categories from best ranking to worst ranking>
If you use SQL, or Python, it will still give you same result
I can still use other ways to do this like power query to custom rank if i want