Day 83 · Sunday, 25 October 2026

From the archive

Intermediate

Award the Second-Lowest Bid with SMALL

LARGE and SMALL pull the kth-ranked value straight out of a range without sorting it, which is exactly what a purchasing rule written as "second-lowest, not lowest" needs.

Task:

You run bid evaluation for a city public-works office that just opened six sealed bids to repave a parking lot. Purchasing policy doesn't award the lowest bid outright — a bid far below the rest is often a sign the contractor underbid and will chase change orders once the work starts, so the contract goes to the second-lowest bid instead. In B8, use SMALL to find that second-lowest bid among the six in B2:B7. In B9, use LARGE and SMALL together to find the spread between the highest and lowest bid, so the review committee can see how wide the range was.

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.