Day 94 · Thursday, 5 November 2026
A purchase email wants one line per supplier, not a filtered table someone has to copy from. FILTER picks out the rows that need ordering and TEXTJOIN folds them into a single comma-separated cell, so the whole reorder list for a supplier comes out of one formula and updates itself when the stock counts change.
You run supplies for a busy outpatient clinic, and every Thursday you email each supplier what to send. The stock count in A2:D10 lists each item, who supplies it, how many are on hand and its reorder point; an item needs ordering when its on-hand count is at or below its reorder point. In G2, write one formula that lists every item the supplier in F2 needs to send, separated by a comma and a space, and shows "Nothing to order" if there are none. Copy it down to G4.
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.