serge
Well-known Member
- Joined
- Oct 8, 2008
- Messages
- 1,444
- Office Version
- 2007
- Platform
- Windows
I have a game that have 3 draws per day so I would need this formula to be modified to add 1 more draw to my columns !
To look like this example below :
This is the formula that I use :
=INDEX($A$3:$K$331,INT((ROWS($1:1)-1)/2)+1,IF(ISODD(ROWS($1:1)),0,6)+COLUMNS($A:A))
Thank you.
To look like this example below :
This is the formula that I use :
=INDEX($A$3:$K$331,INT((ROWS($1:1)-1)/2)+1,IF(ISODD(ROWS($1:1)),0,6)+COLUMNS($A:A))
Thank you.