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:
- How can i take an array, divide it by two and create two lists?
- Most elegant way to convert string array into a dictionary of strings
- In a java enhanced for loop, is it safe to assume the expression to be looped over will be evaluated only once?
- Can't exploit properly an array with twig
- how to use document.getElementById to display the textfield from table using combobox select
- Weird compiler optimization/behavior regarding a "for" loop without a body in Objective-C
- How can I split a string into segments of n characters?
- How to convert int[] to byte[]
- Group rows of a 2d array by a column and create subarrays
- Declare individual variables based on the key names in a 2d array
- Speed up numpy looking for best indices
- Does JavaScript's Array.prototype.fill() always create a packed array?
- Print array without brackets and commas
- Two way binding an array of strings in ng-repeat
- how to pass JSON data though a foreach loop in php
- Pass array value in query post in WordPress
- LINQ - How to correctly group a list of users by their nested list of values
- How can I remove a specific item from an array in JavaScript?
- Remove empty strings from array while keeping record Without Loop?
- What should be the type expression of a 2D array?
- How do I check if an array includes a value in JavaScript?
- Split a 2d array into two 2d grouping arrays by column value
- Jmeter JSON Extractor for Value based off another Value in Array
- Append or prepend to array without VBA/UDF
- JSON schema to enforce array contents
- Javascript: How to implement iterator over multidimensional array?
- Geometric series: calculate quotient and number of elements from sum and first & last element
- How to filter an array to get specific columns in two different objects?
- How to overwrite an array?
- what is array decay in c and when it happen?