Sort and Rank teams Win Loss Draw Tally in round robin tournament

Hi!

I need a ranking system in excel wherein when I put data in the win, loss, and draw, it will interpret it and automatically give me the current rank of a team in a SumoBot Competition.

Please help me.

Thanks!

Hi JammJamm
I'm not sure of the scoring conventions for SumoBot, so you will have to adjust formulas for the relative weights of a win or draw, but this might get you started

Thanks for replying. I already have something like this
TALLY FOR ELIMINATIONS.xlsx
I used the rank function to determine the ranking based on the data given.
What I need to do now is to make the names of the teams appear in descending order according to their ranking.

I am having difficulties using the vlookup function here. Please help me. Thanks in advance ^_^

Originally Posted by FDibbins

I had to use helper column to manage the duplicates (there are 3 5's). see is the attached gives you what you need?

Hi FDibbins ^_^

Thank you for the help. This kinda what I need, but I still need to determine the ranking based on the data in the Win-Loss-Draw columns. For example, groups A,B, and C all have 3 wins, their ranking will be determined by their number of Loss and Draw. Given that A has no Loss and Draw, B has 2 Loss and 1 draw, and C has 2 Loss and 2 draws; ideally, A will be on top followed by B, then C in the ranking.

What function could I use to do be able to do this?

Thank you ^_^

I will think of something. Thank you so much! ^_^