The MAKEARRAY function is a new function added to Excel in February 2022.
It is a helper function for the LAMBDA function to create an cell range of any number of matrices and set the values of any formula.
This MAKEARRAY function has a similar function.
The SEQUENCE function is more appropriate if you simply want to create a sequential number, and the RANDARRAY function is more appropriate if you just want to create random values.
- 1. How it works
- 2. Demonstrate
- 3. Links
How it works
=MAKEARRAY( rows, cols, lambda function )
Number of rows in the cell range to be created.
Number of columns in the cell range to be created.
The following example creates a multiplication table.
The first argument of the LAMBDA function in the MAKEARRAY function is the row index and the second argument is the column index.
The result of the MAKEARRAY function is a cell range, which can be used as an argument to other functions.
The help page includes an example of creating a random list, but this case can be created more succinctly with the RANDARRAY function than with the MAKEARRAY function.