Hello
As you may know in a 4 team group teams should be ranked from 1 to 4 before every match (or matchday) since there are only 4 teams in the group. Their positions may change after every match based on the results they get. I thought this could be achieved by IF function and setting criteria such as Matchday (in column D) and Group (Column G) to distiguish AB:AC values based on those criterias [ IF((D3 = $D$2:$D$28981) * (G3 = $G$2:$G$28981) ].
I input the expected results in columns AD:AE for better understanding for people who aren't into football.
|