Day 94 · Thursday, 5 November 2026

From the archive

Advanced

Build Each Supplier's Reorder Line with TEXTJOIN and FILTER

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.

Task:

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.

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.