League table ranking with 3 criteria

I'm looking at having a league table with 3 different criteria. The criteria I want to 'sort' my table by are, in order:

Points (Column E)
Tie Breaker Question (Column G)
Alphabetical by Player Name (Column D)

The basis of the table is that there is a rank on points. Highest number of points means highest position. If there happens to be 2 teams on the same number of points, then the tie breaker answer comes into play. The lowest the number is in column G the better.

Should the points total, and tie breaker question BOTH be the same, then I would like to 'sort' the league by alphabetical order on player name.

I am able to do a simple rank on points total, but not sure how to rank on LOWEST numerical value of column G ONLY if the points total is the same. Additionally, I don't know how to 'sort' by alphabetical order ONLY if column E and Column G are the same as another team.

Anyway able to give me an idea of how to do this?

It's difficult to advise in detail without seeing your workbook, but one way of approaching the ranking problem is to combine both the points total and the value of column G divided by 1000 in a separate column and use that column for the ranking. the combination can either add or subtract the value of G, depending on the order in which you want to treat the G value. As G is a fractional value, it has only a minor effect on the points. If the names are already in alphabetical order in column D, you can also add on the row number divided by (say) 1000000, to use that within the tie-break.

Hope this helps.

Pete