Aug 03 2021 08:36 AM
Hello,
I have been doing a 33 pool for football every year and I am wondering if there is a easier way to do it.
I have the weeks in columns and teams in rows. All the teams must be used each week but every row will only have 18 teams. Is there a way to do this automatically instead of manual? I always end up with duplicates somehow.
Aug 03 2021 09:00 AM
@GabeToth Not sure, but I think this is similar to something that came up a while ago where a user asked for automating football fixtures. Have a look and see if it works for you.
https://techcommunity.microsoft.com/t5/excel/football-fixture-list-generator/m-p/2489466#M104804
Aug 03 2021 11:15 AM
Aug 03 2021 11:19 AM
@GabeToth Not sure I follow. What's the logic of having blanks in some cells and what's the meaning of the yellow cells?
Aug 03 2021 11:24 AM
Aug 03 2021 11:38 AM
@GabeToth Not sure I understand what you want, but perhaps the attached file helps.
Aug 03 2021 11:45 AM
Aug 03 2021 11:51 AM
@GabeToth Sorry, but what's the logic for having the "yellow" teams exactly where you want them?
Aug 03 2021 11:54 AM