The results will spill in the other rows automatically. Where n is the number of elements in the sequence.įor example, to populate a column with 10 incremental numbers, type the below formula in the first cell (A2 in our case) and press the Enter key: The result is a dynamic array that spills into the specified number of rows and columns automatically. It is a new dynamic array function introduced in Microsoft Excel 365. The SEQUENCE function in Excel is used to generate an array of sequential numbers such as 1, 2, 3, etc.
0 Comments
Leave a Reply. |