Football Pool

Question

Hello,&nbsp;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.&nbsp; All the teams must be used each week but every row will only have 18 teams.&nbsp; Is there a way to do this automatically instead of manual?&nbsp; I always end up with duplicates somehow.

riny_van_eekelen · Answer

GabeToth&nbsp;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.&nbsp;https://techcommunity.microsoft.com/t5/excel/football-fixture-list-generator/m-p/2489466#M104804&nbsp;

gabetoth · Answer

Riny_van_Eekelen If you look at my spreadsheet - I want it to stay how it is but I just want to enter all the teams in week 1 and bye weeks then let excel put them in the rest of the spots without duplicating in a row and column. Is that possible?

riny_van_eekelen · Answer

GabeToth&nbsp;Not sure I follow. What's the logic of having blanks in some cells and what's the meaning of the yellow cells?

gabetoth · Answer

Riny_van_Eekelen below the spread sheet are the teams that are missing from the columns. The yellow are the teams that have a be that week. Instead of me putting the missing teams in and realizing there are duplicates I was hoping there is a formula I could use with column D which has all the teams and then dispurse them across 18 weeks without duplicating them in each row/column

riny_van_eekelen · Answer

GabeToth&nbsp;Not sure I understand what you want, but perhaps the attached file helps.&nbsp;

Forum Discussion

Football Pool

9 Replies