Forum Discussion
HELP with my football league fixtures
Hi i have created a league table for my football(soccer) team, i have created the table and i have created where i insert all fixtures and scores, i have the league table so auto fills the correct ...
Struggling with keeping track of your flag football team's games? Spreadsheet programs like Excel can help! Here's the trick:
1- Big List: Make a big list on one page showing all the games (like Team X vs. Team Y).
2- Team Page: On another page, write down all the team names.
3- Magic Formula: Use a special thing called "VLOOKUP" to automatically find your team's games from the big list. Just tell it the team's name and it'll do the rest!
4- Copy Paste: Once you set it up for one team, copy that magic formula thingy for all the other teams. Now you have a cool list of just your team's games, easy to update and share!