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

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 ^_^