Best on desktop
The spreadsheet workspace needs more room than this screen offers. Switch to a laptop for the full experience.
You're a customer-success analyst computing month-over-month retention for the early-2026 cohorts. The 17-row transactions table (columns A–F) already has two engineered helper columns:
1 on each customer's first-ever order, 0 on later orders1 if (a) this row is the customer's first order and (b) the same customer placed another order in the very next month — 0 otherwiseThe cohort labels are pre-populated in column G (G2=Jan → G5=Apr) and the Retention Rate header sits in H1.
Retention rate per cohort:
retention(cohort) = (count of cohort customers who returned next month) / (cohort size)
Your task:
n (cohort size) and retd (returned count) by filtering on OrderMonth = cohort,retd / n, falling back to 0 when n = 0 so the formula is safe to drag past the data.Graded cells: H2 (Jan → 0.75), H4 (Mar → 0.25), H5 (Apr → 0).