Forum Discussion
Sequencing numbers
How do you sequence numbers in cells from top to bottom then left to right? 1 6 11 2 7 12 3 8 13 4 9 14 5 10 15 etc. fo...
If you have office 365, I think you could try:
=transpose(sequence(100,52))
Otherwise, I believe you could use this (assume the formula is entered in C5 - change cell reference as needed, then copy across/down):
=ROWS(C$5:C5)+(COLUMNS($C5:C5)-1)*52
=transpose(sequence(100,52))
Otherwise, I believe you could use this (assume the formula is entered in C5 - change cell reference as needed, then copy across/down):
=ROWS(C$5:C5)+(COLUMNS($C5:C5)-1)*52