Spreadsheet: 888467d1738948827-excel-version-2019-table-sorting-multiple-criteria-small-tournament
Sheet: Tournament

 | Tournament
 |  |  |  |  |  |  |  |  |  |  |  | Group A - Table |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Data |  |  |  |  | Fixture Data |  |  |  |  |  |  |  |  |  |  |  | Table Draft |  |  |  |  |  |  |  |  |  | Sorting…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group | Team | Code | Team |  | Group | Home |  | Away |  | Winner | [NAME] | Home Draw | Away Draw | Result | Game |  | Team | P | W | L | D | F | A | [NAME] | PTS |  | Team | Rank PTS | [NAME] | Rank F | Rank Total | Rank | Team | H2H | Tie
 |  | Home |  |  | Away |  |  |  | Ref | Result |  |  | Team Calc | Q | Team | P | W | L | D | F | A | [NAME] | PTS |  |  | A | Germany | Team01 |  |  | A |  |  |  |  |  |  |  |  |  | Game01
 | A | Germany |  | 5 | 1 |  | Scotland |  | Ref A |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | Hungary | Team02 |  |  | A |  |  |  |  |  |  |  |  |  | Game02
 | A | Hungary |  | 1 | 3 |  | Spain |  | Ref A |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | Switzerland | Team03 |  |  | A |  |  |  |  |  |  |  |  |  | Game03
 | A | Switzerland |  | 3 | 0 |  | Croatia |  | Ref C |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | Scotland | Team04 |  |  | A |  |  |  |  |  |  |  |  |  | Game04
 | A | Germany |  | 2 | 1 |  | Hungary |  | Ref C |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | Spain | Team05 |  |  | A |  |  |  |  |  |  |  |  |  | Game05
 | A | Scotland |  | 1 | 2 |  | Croatia |  | Ref C |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | Croatia | Team06 |  |  | A |  |  |  |  |  |  |  |  |  | Game06
 | A | Switzerland |  | 1 | 1 |  | Spain |  | Ref C |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw | Draw |  |  | A |  |  |  |  |  |  |  |  |  | Game07
 | A | Germany |  | 0 | 1 |  | Croatia |  | Ref B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game08
 | A | Hungary |  | 3 | 0 |  | Switzerland |  | Ref B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game09
 | A | Scotland |  | 0 | 1 |  | Spain |  | Ref B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game10
 | A | Germany |  | 0 | 1 |  | Switzerland |  | Ref B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game11
 | A | Spain |  | 3 | 1 |  | Croatia |  | Ref A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game12
 | A | Scotland |  | 2 | 1 |  | Hungary |  | Ref A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game13
 | A | Germany |  | 2 | 2 |  | Spain |  | Ref A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game14
 | A | Scotland |  | 2 | 0 |  | Switzerland |  | Ref A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | Game15
 | A | Croatia |  | 1 | 1 |  | Hungary |  | Ref C
 |  |  |  |  |  |  |  |  |  |  |  | Group B - Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Data |  |  |  |  | Fixture Data |  |  |  |  |  |  |  |  |  |  |  | Table Draft |  |  |  |  |  |  |  |  |  | Sorting…
 |  | Home |  |  | Away |  |  |  | Ref | Result |  |  | Team Calc | Q | Team | P | W | L | D | F | A | [NAME] | PTS |  |  | Group | Team | Code | Team |  | Group | Home |  | Away |  | Winner | [NAME] | Home Draw | Away Draw | Result |  |  | Team | P | W | L | D | F | A | [NAME] | PTS |  | Team | Rank PTS | [NAME] | Rank F | Rank Total | Rank | Team | H2H | Tie
 | B | Italy |  | 1 | 1 |  | Albania |  | Ref B |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Italy | Team07 |  |  | B |  |  |  |  |  |  |  |  |  | Game16
 | B | Slovenia |  | 1 | 1 |  | Serbia |  | Ref B |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | England | Team08 |  |  | B |  |  |  |  |  |  |  |  |  | Game17
 | B | Denmark |  | 3 | 3 |  | England |  | Ref B |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Albania | Team09 |  |  | B |  |  |  |  |  |  |  |  |  | Game18
 | B | Italy |  | 1 | 2 |  | Slovenia |  | Ref B |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Denmark | Team10 |  |  | B |  |  |  |  |  |  |  |  |  | Game19
 | B | Albania |  | 2 | 1 |  | England |  | Ref A |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Serbia | Team11 |  |  | B |  |  |  |  |  |  |  |  |  | [NAME]
 | B | Denmark |  | 1 | 1 |  | Serbia |  | Ref A |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Slovinia | [NAME] |  |  | B |  |  |  |  |  |  |  |  |  | Game21
 | B | Italy |  | 1 | 0 |  | England |  | Ref A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw | Draw |  |  | B |  |  |  |  |  |  |  |  |  | Game22
 | B | Slovenia |  | 0 | 3 |  | Denmark |  | Ref A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game23
 | B | Albania |  | 1 | 0 |  | Serbia |  | Ref C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game24
 | B | Italy |  | 1 | 0 |  | Denmark |  | Ref C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game25
 | B | Serbia |  | 1 | 3 |  | England |  | Ref C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game26
 | B | Albania |  | 1 | 2 |  | Slovenia |  | Ref C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game27
 | B | Italy |  | 2 | 2 |  | Serbia |  | Ref C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game28
 | B | Albania |  | 0 | 2 |  | Denmark |  | Ref B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game29
 | B | England |  | 1 | 1 |  | Slovenia |  | Ref B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  |  |  |  |  |  |  |  |  | Game30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winner
 |  | Home |  |  | Away |  |  |  | Ref | Result