Day 97 · Sunday, 8 November 2026

From the archive

Intermediate

Build a Walk-Order Pick List with SORT and FILTER

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.

Task:

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.

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.