MAKEARRAY function
Summary
Returns a calculated array of a specified row and column size, by applying a LAMBDA
Syntax
MAKEARRAY(rows, cols, lambda(row, col))
The MAKEARRAY function syntax has the following arguments and parameters:
• rows The number of rows in the array. Must be greater than zero.
• cols The number of columns in the array. Must be greater than zero.
• lambda A LAMBDA that is called to create the array. The LAMBDA takes two parameters: row The row index of the array. col The column index of the array.
• row The row index of the array.
• col The column index of the array.
• rows The number of rows in the array. Must be greater than zero.
• cols The number of columns in the array. Must be greater than zero.
• lambda A LAMBDA that is called to create the array. The LAMBDA takes two parameters: row The row index of the array. col The column index of the array.
• row The row index of the array.
• col The column index of the array.
Example
=MAKEARRAY(3,3,LAMBDA(r,c,r*c))
=MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green")))
=MAKEARRAY(D2,E2,LAMBDA(row,col,CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green")))