Day 97 · Sunday, 8 November 2026
A picker walks the aisles in bin order, not in the order the orders came in. FILTER pulls out only the lines released for picking, and wrapping it in SORT puts them in the order the shelves actually run, so nobody doubles back from aisle C to aisle A.
You run the morning shift in a fulfilment warehouse, and the picker needs a list for the first wave. The sheet in A2:D10 has one line per item, with its bin, quantity and status, but only the lines marked Released are cleared to pick. In F2, write a single formula that lists the Bin, Item and Qty of every Released line, sorted by bin so the picker can walk the aisles from A to C without turning back.
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.