RANK.EQ Not Returning Without Duplicate References

[ejackson37]

Hi Everyone,

I am trying to rank teams in a table for a charity sports event.

I want to rank by:
1. Points (PTS)
2. Goal Difference (GD)
3. Goals Scored (GS)
4. If all are tied, revert to Alphabetical order.

However the formula I have put in, does not return the Alphabetical order.

=RANK.EQ([@PTS],[PTS])+COUNTIFS([PTS],[@PTS],[GD],">"&[@GD])+COUNTIFS([GD],[@GD],[GS],">"&[@GS]+COUNTIFS([Team],"<="&[@Team]))

Where the black team and blue team have drawn 1-1 (testing the formula) it returns them both as Rank 2 however I want black to return as 2 and blue as 3.

The reason I'm using a table and Rank.EQ is because I want this to be live update as the event goes on.

Can anyone help please?

Thank you. You're a great community that has always solved issues I have had

 

[Fluff]

If Table9 is just to get the sorted list, you could get rid of it & just use

=SORT(VSTACK('Player Stats'!B12:D31,'Player Stats'!H12:J31,'Player Stats'!N12:P31,'Player Stats'!T12:V31),{3,1},{-1,1})

 

[ejackson37]

Wow, that worked! Thank you so much. It blows my mind how fast you can resolve these problems.

 

[Fluff]

You're welcome & thanks for the feedback.