Returns a calculated array of a specified row and column size by applying a LAMBDA function.
この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。
MAKEARRAY(rows, cols, lambda)The MAKEARRAY function creates a new array with the dimensions you specify. It uses a LAMBDA function to calculate each element based on its row and column index.
=MAKEARRAY(2, 2, LAMBDA(r, c, r*c))結果: {1, 2; 2, 4}
Creates a 2x2 array where each cell value is the product of its row and column index.
Yes, the LAMBDA function can return text, numbers, or even other arrays.