Day 93 · Wednesday, 4 November 2026

From the archive

Intermediate

Find Each Site's Longest Unplanned Outage with MAXIFS

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.

Task:

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.

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.