Hi,
I'm trying to create an automatically updating league table for a soccer league. I'm trying to get the league to have a win column and a loss column where every team name in the table will reference the fixture list to find results with the matching team name (using index and match formulas maybe?) and add 1 win or loss to the appropriate win or loss total. So if team A were on 4 wins then won their next match, after inputting the score the win column would automatically become 5...
In all their fixtures, team A's name is in column J and their score in column K, and all their opponents name in column L and their score in column M. Team A's name is in cell A3, their win record in column B and their loss record in column C. The formula i tried which came up with an error was:
=If(index(K3:K12,match(A3,J3:J12,0)))>f(index(M3:M12,match(A3,J3:J12,0))),1,0
I'm not sure how to create a working formula for this! Any help appreciated!
Bookmarks