LogicalLevel: ExpertAvailable in: Excel 365 / 2021+
In this article
- Syntax
- Examples
- Example 1
- Related functions
MAKEARRAY builds an array of a given size, computing each cell from its row and column number.
Syntax
=MAKEARRAY(rows, cols, LAMBDA(r, c, calculation))
| Argument |
What it means |
LAMBDA(r, c, …) |
Receives the row and column number. |
Examples
Example 1
=MAKEARRAY(10, 10, LAMBDA(r, c, r*c))
A 10×10 multiplication table.
SEQUENCE · MAP
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong