Secondary sort of League Tables

[Ivanhoe306]

Am trying to put some league tables together for a local amateur football group. Would appreciate help where a secondary sort is required to separate teams tied on points. Goal difference is the tie breaker. Rank and Vlookup is what I've been using for the original sort but how do I then sort for goal difference, already recorded from results. Thanks for any help you can give
William

 

[Robert Mika]

A small portion of your data would be useful.

 

[Ivanhoe306]

Thanks for looking at this. Sample of date below but using Rank and Vlookup seems cumbersome - is there some other way? Secondary sort formula idea would be appreciated.
Team Played Goals for Goals Against Goal Difference Points
Trenton 4 6 7 -1 6
Belleville 4 3 3 0 6

Bayside 4 4 8 -4 4
Sydney 4 3 0 3 4

In this table Belleville should be above Trenton over GD (goal difference) and Sydney should also be above Bayside.

 

[madforgolf]

Why dont you just use the sort filter. it gives you 3 options to sort.