Home/ Questions/Q 3686
In Process
Jesson Holder
Asked: 2022-10-15T09:12:25+00:00

How to create a sequence of numbers with repeat and increment at intervals in google sheets

I need a single cell formula to create a sequence of numbers with a limit in Google Sheets as shown in the image.

3 rows repeat the value

then Increment by 5

enter image description here

how to create a sequence of numbers with repeat and increment at intervals in google sheets
Share

1 Answer

  1. Use this formula, you can adjust the Sequence() and REPT(rg&",",3) parameters to your need.

    In this example Sequence(number_of_unique_numbers,columns,start_at,increment_by)

    And REPT(rg&",",Repeat_N_times)

    =ArrayFormula(FLATTEN(SPLIT(BYROW(SEQUENCE(3,1,5,5), 
 LAMBDA(rg, IF(rg="",,REPT(rg&",",3)))),",")))

    enter image description here

    Used formulas help
    ARRAYFORMULA – FLATTEN – SPLIT – BYROW – SEQUENCE – LAMBDA – IF – REPT

    Share
    Edit
    Follow

    edited 1 hour ago

    answered 1 hour ago

    Osm's user avatar

    Osm
    2,20811 gold badge22 silver badges2020 bronze badges

    Add a comment

    1

    Use MAKEARRAY with FLATTEN. Multiply the row index number by 5:

    =FLATTEN(MAKEARRAY(4,3,LAMBDA(i,j,i*5)))
    Output
    5
    5
    5
    10
    10
    10
    15
    15
    15
    20
    20
    20

    Share
    Edit
    Follow

    answered 9 mins ago

    TheMaster's user avatar

    TheMaster
    42.1k66 gold badges4949 silver badges7575 bronze badges

    Add a comment

    0

    try:

    =INDEX(FLATTEN(5*MAKEARRAY(4, 3, LAMBDA(x, y, x))))

    1

    • 0

Leave an answer

You must login to add an answer.

Need An Account,