Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a marketing analyst optimizing a 4×4 cohort retention matrix. The current approach is 16 separate cells, each computing returns / cohort_size for one (cohort, month) combination. Adding a 5th cohort means 4 more cells; adding a 5th retention month means 4 more cells; both means 9 more cells.
The pre-aggregated source table:
Output area is empty: H1:K1 already has the headers (Retention_M1 → Retention_M4).
Your task:
The pre-365 alternative is 16 =B2/$F$2 cells, four times across, four times down. The spill version is one expression that scales linearly: 5×6 cohort matrix is the same one cell.
Graded cells: H2 (Jan × M+1 → 0.5), J3 (Feb × M+3 → 0.3), K5 (Apr × M+4 → 0.1).