Day 109 · Friday, 20 November 2026

From the archive

Intermediate

Name the Busiest and Quietest Half-Hour with INDEX, MATCH and MAX

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.

Task:

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.

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

August 2026

September 2026

October 2026

November 2026

21
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.