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.
Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Bin | Item | Qty | Status | Bin | Item | Qty | |
| 2 | C-14 | Packing tape 48mm | 6 | Released | ||||
| 3 | A-03 | Bubble wrap roll | 2 | Released | ||||
| 4 | B-07 | Shipping labels 4x6 | 4 | On hold | ||||
| 5 | A-11 | Cardboard box medium | 25 | Released | ||||
| 6 | C-02 | Stretch film | 3 | Picked | ||||
| 7 | B-01 | Void fill paper | 1 | Released | ||||
| 8 | A-05 | Cardboard box small | 40 | On hold | ||||
| 9 | B-09 | Mailing bags large | 50 | Released | ||||
| 10 | C-08 | Fragile stickers | 10 | Released |
A pick list is only as good as the route it gives, and the sheet lists lines in the order orders arrived, which jumps from C-14 to A-03 and back out to C-08. FILTER(A2:C10, D2:D10="Released") does the first job: it returns the bin, item and quantity of the six lines cleared to pick, as one block that spills from F2. The test has to name Released rather than rule out On hold, because the sheet has a third status: the stretch film in C-02 is already Picked, and D2:D10<>"On hold" would send someone to fetch it twice. Left there, the list still starts at C-14, so the picker crosses the whole warehouse and comes back. SORT fixes that without any extra arguments, because by default it sorts on the first column of what it is given, and the bin is the first column FILTER returns. The order of the wrapping matters: SORT around FILTER sorts only the six lines that survived, rather than the whole sheet. And because the bins are zero-padded (A-03, not A-3), sorting them as text runs A-03, A-11, B-01 in the same order as the shelves. Because the list is a formula, a line released at 9am joins the route in its right place the moment its status changes.