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...
Harry435With Excel MS365 or 2021 that would be:
=TRANSPOSE(SEQUENCE(100,52,1,1))
or if you are an Office Insider, you could transform the formula provided by JMB17 into a LAMBDA function like this:
=MAKEARRAY(52,100,LAMBDA(r,c,r+(c-1)*52))
Both will spill an array of the dimension you specified with sequential numbers, starting at 1, going down 52 rows in the first column and continue on the first row of the second, and so on.
My initial example was wrong as 1 can start in any cell in the first column. See in my detailed reply. Thanks.
Harry435 Well. That's cleared then, but for the record you'll end up with 101 columns. Not 100.
- Thanks Riny. Yes 101 columns. Column 1 starts at 0.