Excel like a finance pro.
← The libraryPractice · 2 questions →
Logical function
MAKEARRAY
Builds an array of a given size by calling a LAMBDA with each row and column number.
Rarely usedDifficulty 1800 · ExpertUsage rank #105 of 520
When to use it
Builds an array of a given size by calling a LAMBDA with each row and column number.
The shape of it
- Syntax
=MAKEARRAY(rows, columns, lambda)
Worked examples
Multiplication grid
=MAKEARRAY(2,3,LAMBDA(r,c,r*c)) → {1,2,3;2,4,6}
A multiplication grid.
Identity matrix
=MAKEARRAY(3,3,LAMBDA(r,c,IF(r=c,1,0))) → {1,0,0;0,1,0;0,0,1}
An identity matrix.
Date column
=MAKEARRAY(12,1,LAMBDA(r,c,EOMONTH(A1,r-1))) → twelve month-ends
A column of month-end dates from A1.
Worth knowing
- SEQUENCE covers simple counters; MAKEARRAY is for anything that depends on both row and column.
- Amortization schedules and calendars are natural uses.
- Rows and columns must be positive.
Where it goes wrong
- Requires Microsoft 365.
- #VALUE! for non-positive dimensions.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.