Hi There,

I'm looking to create a spreadsheet where I enter a number into a cell (A2 in this case) and then that will auto fill the cells in every other row with the next sequential number but once it gets to say row cell A24 I would like it to start in column C and vice versa for every other column (see attached image for reference).
I've found the following formula that achieves the every other row part but I'm stuck on how to continue that when I want to move to the next column.
=IF(ISNUMBER(OFFSET(A2,-1,0)),"",MAX($A$1:OFFSET(A2,-1,0))+1)
I've attached an image that shows what I'm trying to achieve.

Any help on this would be greatly appreciated.

Many thanks,

Dom
Excel.JPG