![]() Sequence that moves vertically top to bottom (row-wise): Please pay attention rows and columns are supplied in different order! Here, we input all the parameters in separate cells (E1:E4) and create 2 sequences with the below formulas. To better understand the approach, please have a look at the screenshot below. TRANSPOSE(SEQUENCE( columns, rows, start, step))įor example, to fill 5 rows and 3 columns with sequential numbers starting at 100 and incremented by 10, the formula takes this form: Please note that TRANSPOSE swaps rows and columns, so you should specify them in the reverse order: top to bottom across the first column and then right to the next column, nest SEQUENCE in the TRANSPOSE function. When populating a range of cells with sequential numbers, by default, the series always goes horizontally across the first row and then down to the next row, just like reading a book from left to right. To generate a descending sequential series, such that each subsequent value is less than the preceding one, supply a negative number for the step argument.įor example, to create a list of numbers starting at 10 and decreasing by 1, use this formula:įorce a two-dimensional sequence to move vertically top to bottom Make a decreasing (descending) sequence in Excel Though the basic SEQUENCE formula does not look very exciting, when combined with other functions, it takes on a whole new level of usefulness. How to create a number sequence in Excel - formula examples ![]()
0 Comments
Leave a Reply. |