![]() Normally we depend on the Row function (single column) or Column function (single row) together with the ArrayFormula for such outputs. In addition to this, this Sequence function in Sheets can be used to generate sequential numbers vertically (single column) or horizontally (single row). Further, you have the option to provide a step value to control the numbers generated.įor example, if you provide #5 as the step value and start value as #0, the numbering will be like 0, 5, 10, 15, etc. The easiest way to generate an array of sequential number in Google Sheets is by using the Sequence function, not by using the Row function as below.įor example, you can replace the =ArrayFormula(row(A1:A10)) formula with a simple =SEQUENCE(10) formula.īy using Google Sheets Sequence function, you can generate a single as well as multiple column array of sequential numbers. ![]() The Sequence function in Google Sheets is categorized under the Maths functions (Insert > Function > Maths).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |