The array can be one-dimensional, or two-dimensional, controlled byrowsandcolumnsarguments.
SEQUENCE can be used on its own to create an array of sequential numbers thatspilldirectly on the worksheet.
The SEQUENCE function takes fourarguments:rows,columns,start, andstep.
All values default to 1.
The rows and columns arguments control the number of rows and columns that should be generated in the output.
The result is 50 numbers starting at 0 and ending at 147, as shown in the screen.
Positive and negative
SEQUENCE can work with both positive and negative values.
SEQUENCE with text
SEQUENCE generates numeric arrays.
However, it is possible to use SEQUENCE to create arrays that contain text.
TheCHAR functionreturns a specific character based on itsASCII number.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
Values can be sorted by one or more columns.
SORT returns a dynamic array of results.
The range or array used to sort does not need to appear in results.
RANDARRAY Function
The Excel RANDARRAY function generates an array of random numbers between two values.
The size or the array is specified byrowsandcolumnsarguments.
The generated values can be either decimals or whole numbers.
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.
