Dans this juicy secret, we’ll explore the powerful MAKEARRAY function and how to use it in Google Sheets. Whether you want to create a customized table or repeat text or symbols in a specified range, MAKEARRAY has got you covered.
Qu’est-ce que la fonction MAKEARRAY dans Google Sheets?
Imagine a scenario where you need to use the row or column number of a cell as an input value for a calculation, or you simply want to repeat text or symbols in a specific range. This is where the MAKEARRAY function comes to the rescue.
The generic formula looks like this:
=MAKEARRAY(Rows, Columns, Lambda)Here’s what each parameter does:
- Rows: This indicates the number of rows in the table you’re creating.
- Columns: This indicates the number of columns in the table you’re creating.
- Lambda: Enter the LAMBDA function as “LAMBDA(RowNumber, ColumnNumber, RowNumber + ColumnNumber)”. You can also enter text, numbers, dates, or formulas without referencing the defined placeholders. In this MAKEARRAY formula, the LAMBDA function performs an operation in each cell of the created table, using the row and column numbers of each cell (not those of Google Sheets) as input values.
So, you need to define two placeholders in the LAMBDA function, one corresponding to a row number and the other corresponding to a column number. Make sure you have enough space for this formula as it spreads the results across the specified table. You can use your named functions here.
For example, let’s say you need to create a 5×5 multiplication table in Google Sheets. Instead of manually typing each calculation and answer into the table one by one, use the MAKEARRAY formula. Once you input the MAKEARRAY formula in a cell, it automatically populates the results in the 5×5 table.
This formula works visually, allowing you to see the multiplication factors in a cell corresponding to the row and column numbers of the cell.
Comment insérer la formule MAKEARRAY dans Google Sheets
Now that you’re excited to try out the MAKEARRAY function, here’s how you can insert it into your Google Sheets:
- Type “=MAKEARRAY” or go to “Insert” -> “Function” -> “Table” -> “MAKEARRAY”.
- Set the size of the table you want to create by entering the number of “rows” and “columns”.
- Enter a LAMBDA function with placeholders and logic.
- Press the “Enter” key.
Now you know how to use the MAKEARRAY function in Google Sheets to create customized tables using the LAMBDA function. Explore different possibilities and enhance your productivity with this powerful feature.
To learn more about other useful functions in Google Sheets, visit Crawlan.com. Remember, your bestie for all things Sheets is just a click away!
