Hi everyone
I am trying to edit couple of things in this template that I found online but I am a bit overwhelmed and I do not know where to put my hands, or better my cursor
What I want to edit:
- Fixtures format (VBA)
- Scores method (Formula)
Let me explain better
Point 1: *Optional
This is how the formatting is by default
Screenshot 2025-01-30 134525.png
This is how I want it (I have achieved this by deleting manually the rows I don't need) but if could be done automatically will be great, but it is not a major thing
Screenshot 2025-01-30 134803.png
Point 2: *IMPORTANT
I am preparing the spreadsheet for a Table Football tournament, 3 points will be awarded for each match, if a team wins 2 games one after another will get 3 points, the looser will get 0.
But if in a match there will be an initial draw so both team will win 1 game, then there will be a third game to have a winner, in this case 2 points will go to the team who wins 2 games and 1 to the loosing team.
In the spreadsheet I am attaching the scoring works differently there is only winner and looser who gets respectively 3 or 0 points, can anyone help me achieve the result I am looking for? Thank you soo much in advance
Bookmarks