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

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

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

Time：10-15

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

CodePudding user response：

Use this formula, you can adjust the

Option 02
Based on

Used formulas help

or:

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