Day 39 · Friday, 11 September 2026

From the archive

Advanced

Report a call center's hold times without one outlier setting the headline number

LARGE and SMALL pick the nth-ranked value straight out of a range, and paired with SUM, MAX, MIN and COUNT they build a trimmed average without deleting a single row.

Task:

You supervise the afternoon shift at a customer support call center. Seven calls came through today, each logged with its hold time in minutes. For the shift report, work out the second-longest hold time in B9 and the second-shortest hold time in B10 — so a single freak call never gets quoted as "the" longest or shortest wait. Then in B11 work out the average hold time with that one longest and one shortest call set aside, so an unusually bad or unusually lucky connection doesn't skew the number you report up the chain.

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

18
SolvedOpenProLatest

Recent days

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