Ranking employees performance from best to worst

%3CLINGO-SUB%20id%3D%22lingo-sub-2890722%22%20slang%3D%22en-US%22%3ERanking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890722%22%20slang%3D%22en-US%22%3EHi%20how%20can%20I%20rank%20these%20employees%20from%20best%20to%20worst%20in%20excel%20%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2890722%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2890890%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890890%22%20slang%3D%22en-US%22%3EBased%20on%20the%20data%20you%20have%20given%26lt%3B%20question%20is%3F%20what%20criteria%20do%20you%20think%20are%20the%20best%20peaked%20period%20for%20deliver%3F%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20can%20tell%20me%2C%20i%20use%20formula%20to%20calculate%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2890899%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890899%22%20slang%3D%22en-US%22%3E%3CP%3EDelivered%20order%2C%20Delivery%20time%20and%20acceptance%20rate%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891048%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195554%22%20target%3D%22_blank%22%3E%40tatto330%3C%2FA%3E%26nbsp%3BDone!I%20used%20RankEQ%20Function%20and%20then%20ranked%20each%203%20categories%20%22%20by%26nbsp%3B%3CSTRONG%3EBest%20to%20Worst%20Ranking%20by%20Delivered%20orders%3C%2FSTRONG%3E%22%20then%20%26gt%3B%20by%26nbsp%3B%3CSTRONG%3ERank%20by%20Best%20to%20Worst%20Bad%20rated%20orders%20%26gt%3B%20by%20Best%20to%20worst%20Ranking%20Orders%20in%20peak%20hours*%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThen%2C%20logically%20you%20need%20to%20sort%20by%20three%20categories%20from%20best%20ranking%20to%20worst%20ranking%26gt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIf%20you%20use%20SQL%2C%20or%20Python%2C%20it%20will%20still%20give%20you%20same%20result%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EI%20can%20still%20use%20other%20ways%20to%20do%20this%20like%20power%20query%20to%20custom%20rank%20if%20i%20want%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22sortMultiple3-768x427.png%22%20style%3D%22width%3A%20768px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320474i3F7888425DBFC95F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22sortMultiple3-768x427.png%22%20alt%3D%22sortMultiple3-768x427.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891067%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891067%22%20slang%3D%22en-US%22%3EOh%2C%20iforget%20to%20add%20Acceptance%20rate%20as%20well%20as%20criteria%20ranking%3F%20let%20me%20redo%20for%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891136%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891136%22%20slang%3D%22en-US%22%3EThanks%20will%20be%20waiting%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891137%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891137%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1195554%22%20target%3D%22_blank%22%3E%40tatto330%3C%2FA%3E%26nbsp%3BDone!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891146%22%20slang%3D%22en-US%22%3ERe%3A%20Ranking%20employees%20performance%20from%20best%20to%20worst%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891146%22%20slang%3D%22en-US%22%3EThank%20you%20bro%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2891161%22%20slang%3D%22en-US%22%3EBro%20please%201%20last%20task%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2891161%22%20slang%3D%22en-US%22%3EPlease%20bro%20help%20me%20to%20solve%20this%20last%20task%3C%2FLINGO-BODY%3E
Contributor
Hi how can I rank these employees from best to worst in excel ?
17 Replies
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?

Delivered order, Delivery time and acceptance rate 

@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 wantsortMultiple3-768x427.png

 

 

 

Oh, iforget to add Acceptance rate as well as criteria ranking? let me redo for you
Thanks will be waiting

@tatto330 Done!

Thank you bro
Please bro help me to solve this last task
Please please help me to solve this issue in the attached file
ok! let me check the file and what it is
Thanks
Some information is wrong here for example. Calculate Average delivered order duration in UA but i can't find the information "UA" on the data given?
Pleas see this updated file. All those cities are in one country

@tatto330 Done! Created a model for the calculations! I want to sleep now it is 11.pm Nigerian Local time! 

Thanks a lot bro
Good night bro
Hello bro how are you doing?
Please do you have any idea how to solve this? Please see attached