Stages
Just playMission 1/6
One cell, a whole table
- Forty canteen sales sit on one tab, and nothing reads them.
- Add a second tab and ask UNIQUE, FILTER or SORT for a table.
Do thisMission 2/6
A list that writes itself
Do thisMission 3/6
Just the rows that match
Do thisMission 4/6
Biggest first, log untouched
Do thisMission 5/6
Each list reads its column
Do thisMission 6/6
Leave room for the table
★★★
Run cleared.
🚀 Push it
- 🟢Add a second view that keeps one stall's rows only.
- 🟡Put the stall list into alphabetical order without touching the log.
- 🔴Say what the menu filter does that a FILTER formula does not.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample workbook, every list and view one formula.
Twist: change the last sale's stall to one the log has never had and watch the list grow.
🧑🏫 Teacher Guideclick to open
⏱ 53015
✅ Watch for
- Stall names typed by hand instead of grown by one formula
- A view made by hiding rows, so the log disappears for everyone
- A note parked under a table formula, blocking every row