Day 87 · Thursday, 29 October 2026

From the archive

Intermediate

Route Refund Tickets to Billing with ISNUMBER and SEARCH

SEARCH answers "where is this word?" with a position or an error, never with yes or no. Wrapping it in ISNUMBER turns that answer into the TRUE or FALSE an IF can route on, and SEARCH ignores case, so a shouted REFUND counts as much as a quiet one.

Task:

You run the support inbox for an online kitchenware shop. Any ticket whose subject mentions a refund — anywhere in the line, in any capitalisation — goes to the Billing queue; everything else goes to General. In column C, use IF with ISNUMBER and SEARCH to look for "refund" in each subject in column B and return "Billing" or "General". 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.