Day 65 · Wednesday, 7 October 2026
From the archive
Queue a maintenance team's repair requests by priority without touching the log
SORTBY can carry two columns along for a sort keyed on a third, so the call log it reads from never has to move.
Task:
You coordinate the on-call maintenance team for a 40-unit apartment building. Requests get logged in the order residents call them in, which is not the order the tech should work them — a leaking faucet phoned in first thing shouldn't sit ahead of a gas smell reported an hour later. Each request carries a priority: 1 for an emergency, 2 for urgent, 3 for routine. The office needs the call log left exactly as it came in, since that's the record they keep, and a separate work order built from it. In F2, use SORTBY to list the unit and issue from A2:B7, ordered by the priority in C2:C7, most urgent first. The queue should spill from F2 down to F7.
The daily challenge is part of Pro
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
Every day so far
Recent days
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.
- 74Day 74 · Friday, 16 October 2026Build a sorted, duplicate-free category breakdown from a ticket log with UNIQUE, SORT and COUNTIFLatest
- Day 73 · Thursday, 15 October 2026Reduce a batch of screen resolutions to their simplest aspect ratio with GCD
- Day 72 · Wednesday, 14 October 2026Project a reserve fund that already holds a balance and gets monthly top-ups with FV
- Day 71 · Tuesday, 13 October 2026Rank sales reps by quarterly revenue and assign a bonus tier with RANK and nested IF
- Day 70 · Monday, 12 October 2026Decide which product returns qualify for auto-approval with OR wrapping two AND conditions
- Day 69 · Sunday, 11 October 2026Pull a payment term off the end of a purchase order number with a varying number of segments
- Day 68 · Saturday, 10 October 2026Roll a due date that lands on a weekend forward to the next business day with WEEKDAY
- Day 67 · Friday, 9 October 2026Look up a consultant's billing rate from a two-way rate grid with INDEX and MATCH
- Day 66 · Thursday, 8 October 2026Turn a route's duration in minutes into hours and minutes with INT and MOD
- Day 65 · Wednesday, 7 October 2026Queue a maintenance team's repair requests by priority without touching the log
- Day 64 · Tuesday, 6 October 2026Find how much loan principal a cargo van's payment plan pays off in its first year
- Day 63 · Monday, 5 October 2026Find the typical closing price and the most common bedroom count in last month's sales
- Day 62 · Sunday, 4 October 2026Count comma-separated labels on a support ticket, and flag the over-tagged ones
- Day 61 · Saturday, 3 October 2026Project each truck's next service date with EDATE, then flag which ones are overdue