Day 109 · Friday, 20 November 2026
MAX tells you how many calls the busiest half-hour took, but the rota needs to know which half-hour it was. Feeding MAX into MATCH finds where that number sits in the column, and INDEX turns that position into the label beside it.
You run the reception desk at a doctors' surgery, and last Monday's phone log, the calls received in each half-hour from 8:00 to 13:00, is in A2:B11. You want an extra receptionist on the phones for the worst half-hour and the team huddle in the quietest one. In E2, return the time slot that received the most calls, and in E3, the slot that received the fewest. Both answers should be the slot label from column A, not a number of calls, and should still be right when next Monday's figures are pasted over these.
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.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.