How to generate a repeating sequence of numbers in Google Sheet?
What I need is quite simple, yet somehow I can't get around to find a solution for it.
Basically what I need is for a column, starting from its second row to look list numbers from 1 to 15 and have that sequence repeated all the way to the bottom of the sheet automatically. I was thinking about using arrayformula but couldn't figure out the formula for it.
Essentially something like this but it goes all the way down automatically.
Solution
Explanation:
You can repeat (REPT) a sequence of numbers from 1 to 15 by using the Sequence formula.
The maximum number of times you want to repeat this sequence will be determined by the total number of rows in your sheet divided by 15.
Solution:
=transpose(split(REPT(concat(JOIN(",",SEQUENCE(1,15)),","),ROUNDDOWN(ROWS(A1:A)/15)),",",true))
Output:
- Not able to iterate through all the rows in 2D array in Row-Wise Binary Search
- How can I remove a specific item from an array in JavaScript?
- Get the last item in an array
- Searching for part of a string within an array
- Fastest way to convert Image to Byte array
- How to quickly find the minimum element to the right for every element of a Numpy array?
- JS sort array of pair with null and empty values at the end
- bash script to Echo multiple lists
- storing char in char array - incompatible types in assignment of char to char[]
- Inserting JSON data with 'insertAdjacentElement' instead of 'innerHTML'
- Extract associative array elements into individual variables
- How can I loop through enum values for display in radio buttons?
- Split a comma-delimited string into an array?
- How to transform array into desired output using jolt
- How to override only method signature in typescript?
- How do I remove an element from an array at a specified index but not do the operation in-place
- Using array values to select database table in laravel
- Custom Fields - Repeater dropdown - list only unique & not blank values
- Get taxonomies in a category archive page
- How can I compare a clicked elements ID with another ID?
- Unexpected memory allocation when using array views (julia)
- How can I check if a lua table contains only sequential numeric indices?
- Snowflake - challenge in accessing objects in an array
- Convert a Result Set from SQL Array to Array of Strings
- How to convert an array into an object?
- How do I know an array contains all zero(0) in Javascript
- JS create array from a sorted array of pairs
- Insert array into MySQL database with PHP
- How to explode only on the last occurring delimiter?
- Java two varargs in one method