MAKEARRAY can be used to create arrays with variable dimensions that are calculated.
Thefunctionis a custom LAMBDA (see below) to use when creating values in the array.
The total number of values in the array returned by MAKEARRAY will equal rows * columns.
LAMBDA structure
The MAKEARRAY uses theLAMBDA functionto apply the function used to calculate array values.
Note: to generate an array with sequential values, see theSEQUENCE function.
Thecalculationcan be a hardcoded value as well.
In the formula below.
LET Function
The Excel LET function lets you define named variables in a formula.
BYCOL can apply stock functions like SUM, COUNT, and AVERAGE or a custom LAMBDA function.
BYROW can apply stock functions like SUM, COUNT, and AVERAGE or a custom LAMBDA function.
All results are returned at the same time in a single array….
