• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formula to create a sequence

upload_2017-2-20_9-44-48.png

1] Sequence in column formula :

=ABS(MOD(ROWS($1:1)-1,3)+1-4*(MOD(INT((ROWS($1:1)-1)/3),2)))

2] Sequence in row formula :

=ABS(MOD(COLUMNS($A:A)-1,3)+1-4*(MOD(INT((COLUMNS($A:A)-1)/3),2)))

Regards
Bosco
 

Attachments

  • Sequence in rows columns.xlsx
    10.1 KB · Views: 1
Hey not sure your requirment but another way without formula.


Fill a column with a series of numbers
  1. Select the first cell in the range that you want to fill.
  2. Type the starting value for the series.
  3. Type a value in the next cell to establish a pattern. ...
  4. Select the cells that contain the starting values. ...
  5. Drag the fill handle across the range that you want to fill.
 
View attachment 38676

1] Sequence in column formula :

=ABS(MOD(ROWS($1:1)-1,3)+1-4*(MOD(INT((ROWS($1:1)-1)/3),2)))

2] Sequence in row formula :

=ABS(MOD(COLUMNS($A:A)-1,3)+1-4*(MOD(INT((COLUMNS($A:A)-1)/3),2)))

Regards
Bosco

thank you for this. how would i change this to go up to 5 then back down?
so,
1
2
3
4
5
5
4
3
2
1
do i have to change the divisor?
 
Back
Top