Dynamic array with SEQUENCE function
Excel 365supportsdynamic array formulas.
In Excel 365, theSEQUENCE functioncan generate dynamic number arrays in one step.
For example, =MID(“apple”,2,3) returns “ppl”.
INDIRECT Function
The Excel INDIRECT function returns a valid cell reference from a given text string.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
SEQUENCE Function
The Excel SEQUENCE function generates a list of sequential numbers in an array.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
