Forum Discussion
Football Pool
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 wee...
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?
GabeToth Not sure I follow. What's the logic of having blanks in some cells and what's the meaning of the yellow cells?
- 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
GabeToth Not sure I understand what you want, but perhaps the attached file helps.
- Riny_van_Eekelen that looks great but I need the bye teams (yellow) to be how I have them as and still maintain no duplicates so for example in Week 5 I need ATL, NO, NYJ, SF to be there