Day 81 · Friday, 23 October 2026

From the archive

Intermediate

Build a single modifications line for a café order ticket with TEXTJOIN, then flag the busy ones with COUNTA

TEXTJOIN's ignore_empty argument is what keeps a half-filled order from printing a trail of empty commas on the kitchen screen — and the same blanks it steps over are exactly what COUNTA is built to count.

Task:

A café's point-of-sale system exports each drink order with three customization columns — Milk, Syrup and Topping — but most customers only fill in one or two of them, leaving the rest of that row blank. In column F, join together whichever of those three columns an order actually has into one readable line for the kitchen screen. In column G, mark the order "Yes" if it carries two or more customizations and "No" otherwise. Fill in rows 2 through 7.

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.