MAKEARRAY: Multiplication Tables, Rotas and Payment Schedules
This lesson is part of the course
In this lesson
You generate three grids for Alder & Finch from a row and column number alone: a crate × pack-size table, a weekly showroom rota and an instalment plan.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- LET: Name Your Intermediate Results for Readable, Faster Formulas Locked
- LAMBDA Basics: Parameters, a Calculation and Calling It Inline Locked
- Named LAMBDAs: TaxPrice, MarginPct and Your Own Workbook Functions Locked
- BYROW and BYCOL: One Formula for Every Row or Column Locked
- MAP: Your Own Logic for Every Element, Even with AND and OR Locked
- REDUCE and SCAN: Running Totals, Compounding and Final Balances Locked
- MAKEARRAY: Multiplication Tables, Rotas and Payment Schedules Locked
- Capstone: Refactor a Nested Commission Formula into LET and LAMBDA Locked