League Position in Rows of data

Hello

So Ideally 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 AC:AD in the original document above.

Hello

So Ideally 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 AC:AD in the original document above.

Well, I have a not perfect solution for you, if you drag down K2 to AD3 the formula will work, the function RANK.EQ() isn't accepting a formula inside it, you probably tried it too, I will keep looking for a optimal solution.

Formula:

Please Login or Register  to view this content.