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...
Harry435 HI HARRY,
to make an array in a specific sequence, you need sequence function within excel
=SEQUENCE(rows,column,start,step)
in rows enter user defined rows
in column enter user defined columns
start- which number you want to start with eg started with 5
step- what difference the step should be , eg 2, which means add 2 to 5 through out array.
result
array work from left to right