Day 83 · Sunday, 25 October 2026
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.
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.
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.