You can do this without a macro.
In cells A1 to A3 enter the numbers 1 to 3.
In cell A2:
=IF(AND(B1=31,C1=32),A1+1,A1)
In cell B2:
=IF(AND($C1<32,$B1<=31),$B1,0)+IF(AND(C1=32,B1<31) ,B1+1,0)+IF(AND(B1=31,C1=32),A2+1,0)
In cell C2:
=IF(C1<32,C1+1,B2+1)
Copy cells A2:C2 to A2:C4960.

"Bluesters" wrote:


Math Question for football pool

--------------------------------------------------------------------------------

Does anyone know where I can obtain software that would enable me to
print out all 4,960 3 team football combinations using the 32 NFL teams
(Order does not matter), it would be used for a pool I'm running.

Thanks



--------------------------------------------------------------------------------

I want to make sure I understand

Team A, Team B, Team C
Team A, Team B, Team D
Team A, Team B, Team E