Excel & Sheets practice: Sequence Generation & Array Reshaping
Chapter 27 · 2 questions · included in full access
Question 1 · easy
Month starts for 2026
Solve it in your browserSpill the first day of every month of 2026 (12 dates) from K2, with one formula.
Question 2 · medium
Count a spilled list
Solve it in your browserM2 already holds
=UNIQUE(D2:D21), spilling the list of reps. In K2, count the reps by referring to the whole spill with the spill operator.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing