Day 93 · Wednesday, 4 November 2026
An incident log mixes planned maintenance with genuine breakdowns, and the biggest number in it is usually a planned shutdown nobody needs to explain. MAXIFS takes the largest value only from the rows that pass every condition you give it, so one formula can ask for the worst breakdown at each site and ignore the rest.
You are the operations analyst for a parcel distribution network, preparing the October reliability review. The incident log in A2:D11 records every time a site's sorting line stopped, whether it was a planned maintenance window or an unplanned breakdown, and for how many minutes. In G2, use MAXIFS to return the longest unplanned outage at the site in F2, then copy it down to G5. Planned stoppages must not count.
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.