From the archive

Day 20

Sunday, 23 August 2026

Day 19Day 21
Intermediate

Pull the items that need reordering off a warehouse count

FILTER hands back only the rows that pass a test — no manual scan, no separate list to keep in sync.

Task:

You manage inventory for a hardware store's warehouse. This morning's stock count is in front of you, and purchasing wants a reorder list — just the items that have dropped below 20 units on hand, with their quantities, so nobody has to scroll the full count to find them. In E2, use FILTER to list every item with fewer than 20 units, along with how many are left.

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.

See what Pro includesBack to the latest

Recent days

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