Returns a calculated array of a specified row and column size by applying a LAMBDA function.
Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.
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))Risultato: {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.