Spreadsheet: 73204d1273844255-how-to-sort-soccer-league-tables-for-world-cup-spreadsheet-vlookup-rank-world-cup-sample
Sheet: Sheet1

2010-05-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | Winner | [NAME]
 |  |  |  |  |  | Group Stage |  |  |  |  |  |  |  |  |  | Group A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South Africa |  | F | A |  |  |  | Mexico |  | F | A |  |  |  | Uruguay |  | F | A |  |  |  | France |  | F | A
 | Date | GMT | Match |  |  |  |  | Stadium | Location | Gp |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | D | L | F | A | [NAME] | PTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | France | 3 | 2 | 1 | 0 | 6 | 4 | 2 | 7 |  |  |  |  |  |  |  |  |  |  |  | Game 1 | 0 | 1 | 2 | 0 |  |  | Game 1 | 3 | 2 | 1 | 3 |  |  | Game 1 | 1 | 2 | 2 | 1 |  |  | Game 1 | 1 | 2 | 2 | 1 |  |  |  |  | France | 2 | 1 | 0 | 6 | 4 | 2 | 7
 | 2010-06-11 00:00:00 | 15:00:00 | 1 | South Africa | 1 | 2 | Mexico | Soccer City | [NAME] | A | Mexico | South Africa |  |  | 2 | South Africa | 3 | 0 | 1 | 2 | 3 | 5 | -2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | x |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | South Africa | 0 | 1 | 2 | 3 | 5 | -2 | 1
 | 2010-06-11 00:00:00 | 19:30:00 | 2 | Uraguay | 2 | 2 | France | Green Point | Cape Town | A | Draw | Draw |  |  | 3 | Mexico | 3 | 2 | 0 | 1 | 5 | 4 | 1 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  |  | Mexico | 2 | 0 | 1 | 5 | 4 | 1 | 6
 | 2010-06-12 00:00:00 | 15:00:00 | 3 | Argentina |  |  | Nigeria | Ellis Park | [NAME] | B |  |  |  |  | 4 | Uruguay | 3 | 1 | 1 | 1 | 5 | 4 | 1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uruguay | 1 | 1 | 1 | 5 | 4 | 1 | 4
 | 2010-06-12 00:00:00 | 12:30:00 | 4 | South Korea |  |  | Greece | [NAME] | Port Elizabeth | B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game 2 | 1 | 1 | 1 | 1 |  |  | Game 2 | 0 | 1 | 2 | 0 |  |  | Game 2 | 0 | 1 | 1 | 0 |  |  | Game 2 | 3 | 2 | 1 | 3
 | 2010-06-12 00:00:00 | 19:30:00 | 5 | England |  |  | USA | [NAME] | Rustenburg | C |  |  |  |  |  | Group B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | X
 | 2010-06-13 00:00:00 | 12:30:00 | 6 | Algeria |  |  | Slovenia | [NAME] | Polokwane | C |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | X
 | 2010-06-13 00:00:00 | 19:30:00 | 7 | Germany |  |  | Australia | Durban | Durban | D |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-13 00:00:00 | 15:00:00 | 8 | Serbia |  |  | Ghana | Loftus Versfeld | Tshwane | D |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Game 3 | 0 | 1 | 2 | 0 |  |  | Game 3 | 3 | 2 | 1 | 3 |  |  | Game 3 | 3 | 2 | 1 | 3 |  |  | Game 3 | 3 | 2 | 1 | 3
 | 2010-06-14 00:00:00 | 12:30:00 | 9 | Netherlands |  |  | Denmark | Soccer City | [NAME] | E |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  | X
 | 2010-06-14 00:00:00 | 15:00:00 | 10 | Japan |  |  | Cameroon | Free State | [NAME] | E |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  | X
 | 2010-06-14 00:00:00 | 19:30:00 | 11 | Italy |  |  | Paraguay | Green Point | Cape Town | F
 | 2010-06-15 00:00:00 | 12:30:00 | 12 | New Zealand |  |  | Slovakia | [NAME] | Rustenburg | F |  |  |  |  |  | Group C
 | 2010-06-15 00:00:00 | 15:00:00 | 13 | Ivory Coast |  |  | Portugal | [NAME] | Port Elizabeth | G |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts |  |  |  |  |  |  |  |  |  |  |  | W | D | L | F | A | [NAME] | PTS | W | D | L | F | A | [NAME] | PTS | W | D | L | F | A | [NAME] | PTS | W | D | L | F | A | [NAME] | PTS
 | 2010-06-15 00:00:00 | 19:30:00 | 14 | Brazil |  |  | North Korea | Ellis Park | [NAME] | G |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 5 | -2 | 1 | 2 | 0 | 1 | 5 | 4 | 1 | 6 | 1 | 1 | 1 | 5 | 4 | 1 | 4 | 2 | 1 | 0 | 6 | 4 | 2 | 7 |  |  |  |  | GROUP A
 | 2010-06-16 00:00:00 | 12:30:00 | 15 | Honduras |  |  | Chile | Mbombela | Nelspruit | H |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-16 00:00:00 | 15:00:00 | 16 | Spain |  |  | Switzerland | Durban | Durban | H |  |  |  |  | 3 | W | D | L | A | F | [NAME] | PTS | 0 | 0
 | 2010-06-16 00:00:00 | 19:30:00 | 17 | South Africa | 1 | 1 | Uruguay | Loftus Versfeld | Tshwane | A | Draw | Draw |  |  | 4 | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Argentina |  | F | A |  |  |  | Nigeria |  | F | A |  |  |  | South Korea |  | F | A |  |  |  | Greece |  | F | A
 | 2010-06-17 00:00:00 | 19:30:00 | 18 | France | 2 | 1 | Mexico | [NAME] | Polokwane | A | France | Mexico |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | D | L | F | A | [NAME] | PTS
 | 2010-06-17 00:00:00 | 15:00:00 | 19 | Greece |  |  | Nigeria | Free State | [NAME] | B |  |  |  |  |  | Group D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Game 1 | 1 | 0 | 0 | 1 |  |  | Game 1 | 1 | 0 | 0 | 1 |  |  | Game 1 | 1 | 0 | 0 | 1 |  |  | Game 1 | 1 | 0 | 0 | 1 |  |  |  |  | Greece | 0 | 3 | 0 | 0 | 0 | 0 | 3
 | 2010-06-17 00:00:00 | 12:30:00 | 20 | Argentina |  |  | South Korea | Soccer City | [NAME] | B |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | South Korea | 0 | 1 | 2 | 3 | 5 | -2 | 1
 | 2010-06-18 00:00:00 | 12:30:00 | 21 | Germany |  |  | Serbia | [NAME] | Port Elizabeth | D |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |  |  |  | Nigeria | 2 | 0 | 1 | 5 | 4 | 1 | 6
 | 2010-06-18 00:00:00 | 15:00:00 | 22 | Slovenia |  |  | USA | Ellis Park | [NAME] | C |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Argentina | 1 | 1 | 1 | 5 | 4 | 1 | 4
 | 2010-06-18 00:00:00 | 19:30:00 | 23 | England |  |  | Algeria | Green Point | Cape Town | C |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Game 2 | 1 | 0 | 0 | 1 |  |  | Game 2 | 1 | 0 | 0 | 1 |  |  | Game 2 | 1 | 0 | 0 | 1 |  |  | Game 2 | 1 | 0 | 0 | 1
 | 2010-06-19 00:00:00 | 15:00:00 | 24 | Ghana |  |  | Australia | [NAME] | Rustenburg | D |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
 | 2010-06-19 00:00:00 | 12:30:00 | 25 | Netherlands |  |  | Japan | Durban | Durban | E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  | X
 | 2010-06-19 00:00:00 | 19:30:00 | 26 | Cameroon |  |  | Denmark | Loftus Versfeld | Tshwane | E |  |  |  |  |  | Group E
 | 2010-06-20 00:00:00 | 12:30:00 | 27 | Slovakia |  |  | Paraguay | Free State | [NAME] | F |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts |  |  |  |  |  |  |  |  |  |  |  | Game 3 | 1 | 0 | 0 | 1 |  |  | Game 3 | 1 | 0 | 0 | 1 |  |  | Game 3 | 1 | 0 | 0 | 1 |  |  | Game 3 | 1 | 0 | 0 | 1
 | 2010-06-20 00:00:00 | 15:00:00 | 28 | Italy |  |  | New Zealand | Mbombela | Nelspruit | F |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
 | 2010-06-20 00:00:00 | 19:30:00 | 29 | Brazil |  |  | Ivory Coast | Soccer City | [NAME] | G |  |  |  |  | 2 | 0 | GROUP B | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  | X |  |  |  |  |  |  | X
 | 2010-06-21 00:00:00 | 12:30:00 | 30 | Portugal |  |  | North Korea | Green Point | Cape Town | G |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-21 00:00:00 | 15:00:00 | 31 | Chile |  |  | Switzerland | [NAME] | Port Elizabeth | H |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-21 00:00:00 | 19:30:00 | 32 | Spain |  |  | Honduras | Ellis Park | [NAME] | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | D | L | F | A | [NAME] | PTS | W | D | L | F | A | [NAME] | PTS | W | D | L | F | A | [NAME] | PTS | W | D | L | F | A | [NAME] | PTS
 | 2010-06-22 00:00:00 | 15:00:00 | 33 | Mexico | 2 | 1 | Uruguay | [NAME] | Rustenburg | A | Mexico | Uruguay |  |  |  | Group F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 3 |  |  |  |  | GROUP B
 | 2010-06-22 00:00:00 | 15:00:00 | 34 | France | 2 | 1 | South Africa | Free State | [NAME] | A | France | South Africa |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts
 | 2010-06-22 00:00:00 | 19:30:00 | 35 | Nigeria |  |  | South Korea | Durban | Durban | B |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-22 00:00:00 | 19:30:00 | 36 | Greece |  |  | Argentina | [NAME] | Polokwane | B |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-23 00:00:00 | 15:00:00 | 37 | Slovenia |  |  | England | [NAME] | Port Elizabeth | C |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-23 00:00:00 | 15:00:00 | 38 | USA |  |  | Algeria | Loftus Versfeld | Tshwane | C |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-23 00:00:00 | 19:30:00 | 39 | Ghana |  |  | Germany | Soccer City | [NAME] | D
 | 2010-06-23 00:00:00 | 19:30:00 | 40 | Australia |  |  | Serbia | Mbombela | Nelspruit | D |  |  |  |  |  | Group G
 | 2010-06-24 00:00:00 | 15:00:00 | 41 | Slovakia |  |  | Italy | Ellis Park | [NAME] | E |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts
 | 2010-06-24 00:00:00 | 15:00:00 | 42 | Paraguay |  |  | New Zealand | [NAME] | Polokwane | E |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-24 00:00:00 | 19:30:00 | 43 | Denmark |  |  | Japan | [NAME] | Rustenburg | F |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-24 00:00:00 | 19:30:00 | 44 | Cameroon |  |  | Netherlands | Green Point | Cape Town | F |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-25 00:00:00 | 15:00:00 | 45 | Portugal |  |  | Brazil | Durban | Durban | G |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2010-06-25 00:00:00 | 15:00:00 | 46 | North Korea |  |  | Ivory Coast | Mbombela | Nelspruit | G
 | 2010-06-25 00:00:00 | 19:30:00 | 47 | Chile |  |  | Spain | Loftus Versfeld | Tshwane | H |  |  |  |  |  | Group H
 | 2010-06-25 00:00:00 | 19:30:00 | 48 | Switzerland |  |  | Honduras | Free State | [NAME] | H |  |  |  |  | Rank | Team | P | W | D | L | F | A | [NAME] | Pts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Second Round |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Date | GMT | Match |  |  |  |  | Stadium | Venue |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Penalty Winners              (1 = home,                2 = away)
 | 2010-06-26 00:00:00 | 15:00:00 | 49 | France |  |  | [NAME]-Up B | [NAME] | Port Elizabeth |  | Second Rd 6 | Penalties winners? | [NAME]-Up B
 | 2010-06-26 00:00:00 | 19:30:00 | 50 | Winner C |  |  | [NAME]-Up D | [NAME] | Rustenburg |  | Second Rd 6 | Penalties winners? | [NAME]-Up D
 | 2010-06-27 00:00:00 | 15:00:00 | 51 | Winner D |  |  | [NAME]-Up C | Free State | [NAME] |  | Second Rd 6 | Penalties winners? | [NAME]-Up C
 | 2010-06-27 00:00:00 | 19:30:00 | 52 | Winner B |  |  | South Africa | Soccer City | [NAME] |  | Second Rd 6 | Penalties winners? | South Africa
 | 2010-06-28 00:00:00 | 15:00:00 | 53 | Winner E |  |  | [NAME]-Up F | Durban | Durban |  | Second Rd 6 | Penalties winners? | [NAME]-Up F
 | 2010-06-28 00:00:00 | 19:30:00 | 54 | Winner G |  |  | Runner-Up H | Ellis Park | [NAME] |  | Second Rd 6 | Penalties winners? | Runner-Up H
 | 2010-06-29 00:00:00 | 15:00:00 | 55 | Winner F |  |  | [NAME]-Up E | Loftus Versfeld | Tshwane |  | Second Rd 6 | Penalties winners? | [NAME]-Up E
 | 2010-06-29 00:00:00 | 19:30:00 | 56 | Winner H |  |  | [NAME]-Up G | Green Point | Cape Town |  | Second Rd 6 | Penalties winners? | [NAME]-Up G
 | Quarter-Finals
 | Date | GMT | Match |  |  |  |  | Stadium | Venue
 |  |  |  |  |  |  |  |  |  | Penalty Winners              (1 = home,                2 = away)
 | 2010-07-02 00:00:00 | 15:00:00 | 57 | Second Rd 6 |  |  | Second Rd 6 | [NAME] | Port Elizabeth |  | Quarter-Final 1 | Penalties winners? | Second Rd 6
 | 2010-07-02 00:00:00 | 19:30:00 | 58 | Second Rd 6 |  |  | Second Rd 6 | Soccer City | [NAME] |  | Quarter-Final 2 | Penalties winners? | Second Rd 6
 | 2010-07-03 00:00:00 | 15:00:00 | 59 | Second Rd 6 |  |  | Second Rd 6 | Ellis Park | Cape Town |  | Quarter-Final 3 | Penalties winners? | Second Rd 6
 | 2010-07-03 00:00:00 | 19:30:00 | 60 | Second Rd 6 |  |  | Second Rd 6 | Soccer City | [NAME] |  | Quarter-Final 4 | Penalties winners? | Second Rd 6
 | Semi-Finals
 | Date | GMT | Match |  |  |  |  | Stadium | Venue
 |  |  |  |  |  |  |  |  |  | Penalty Winners              (1 = home,                2 = away)
 | 2010-07-06 00:00:00 | 19:30:00 | 61 | Quarter-Final 2 |  |  | Quarter-Final 1 | Green Point | Cape Town |  | Semi-Final 1 | Penalties winners? | Quarter-Final 1
 | 2010-07-07 00:00:00 | 19:30:00 | 62 | Quarter-Final 3 |  |  | Quarter-Final 4 | Durban | Durban |  | Semi-Final 2 | Penalties winners? | Quarter-Final 4
 |  |  |  |  |  |  |  |  |  |  | Semi-Final 1 Losers | Penalties winners? | Quarter-Final 2
 |  |  |  |  |  |  |  |  |  |  | Semi-Final 2 Losers | Penalties winners? | Quarter-Final 3
 | 3rd Place Play-Off
 | Date | GMT | Match |  |  |  |  | Stadium | Venue
 |  |  |  |  |  |  |  |  |  | Penalty Winners              (1 = home,                2 = away)
 | 2010-07-10 00:00:00 | 19:30:00 | 63 | Semi-Final 1 Losers |  |  | Semi-Final 2 Losers | [NAME] | Port Elizabeth |  | Play-Off Winner | Penalties winners? | Semi-Final 2 Losers
 |  | 3rd place: |  | Play-Off Winner
 | Final
 | Date | GMT | Match |  |  |  |  | Stadium | Venue
 |  |  |  |  |  |  |  |  |  | Penalty Winners              (1 = home,                2 = away)
 | 2010-07-11 00:00:00 | 19:30:00 | 64 | Semi-Final 1 |  |  | Semi-Final 2 | Soccer City | [NAME] |  | World Cup Winner | Penalties winners? | Semi-Final 2
 |  | Winner: |  | World Cup Winner