| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Postive Filter w/MATCH | Positive Filter w/COUNTIF | Negative Filter w/MATCH | Negative Filter w/COUNTIF | ||||||||||||||
2 | Team | Points | Goals scored | Teams to Filter | Filtered Team | Filtered Points | Filtered Goals scored | Filtered Team | Filtered Points | Filtered Goals scored | Filtered Team | Filtered Points | Filtered Goals scored | Filtered Team | Filtered Points | Filtered Goals scored | ||
3 | Ukraine | 3 | 4 | Germany | Spain | 7 | 1 | Spain | 7 | 1 | Ukraine | 3 | 4 | Ukraine | 3 | 4 | ||
4 | Sweden | 3 | 5 | Netherlands | Portugal | 6 | 4 | Portugal | 6 | 4 | Sweden | 3 | 5 | Sweden | 3 | 5 | ||
5 | Spain | 7 | 1 | Portugal | Netherlands | 0 | 5 | Netherlands | 0 | 5 | Russia | 4 | 3 | Russia | 4 | 3 | ||
6 | Russia | 4 | 3 | Italy | Italy | 5 | 2 | Italy | 5 | 2 | Republic of Ireland | 0 | 9 | Republic of Ireland | 0 | 9 | ||
7 | Republic of Ireland | 0 | 9 | England | Germany | 9 | 2 | Germany | 9 | 2 | Poland | 2 | 3 | Poland | 2 | 3 | ||
8 | Portugal | 6 | 4 | France | France | 4 | 3 | France | 4 | 3 | Greece | 4 | 3 | Greece | 4 | 3 | ||
9 | Poland | 2 | 3 | Spain | England | 7 | 3 | England | 7 | 3 | Denmark | 3 | 5 | Denmark | 3 | 5 | ||
10 | Netherlands | 0 | 5 | Croatia | Croatia | 4 | 3 | Croatia | 4 | 3 | Czech Republic | 6 | 5 | Czech Republic | 6 | 5 | ||
11 | Italy | 5 | 2 | |||||||||||||||
12 | Greece | 4 | 3 | |||||||||||||||
13 | Germany | 9 | 2 | |||||||||||||||
14 | France | 4 | 3 | |||||||||||||||
15 | England | 7 | 3 | |||||||||||||||
16 | Denmark | 3 | 5 | |||||||||||||||
17 | Czech Republic | 6 | 5 | |||||||||||||||
18 | Croatia | 4 | 3 | |||||||||||||||