Day 89 · Saturday, 31 October 2026

From the archive

Advanced

Build a Collections Call List with FILTER and Two Conditions

FILTER takes one include argument, so a rule with two conditions has to be folded into it. Multiplying the two TRUE/FALSE arrays does that row by row, where AND would collapse the whole range into a single answer.

Task:

You run accounts receivable for a commercial cleaning company. The finance manager wants this afternoon's collections calls limited to invoices that are worth chasing by phone: $1,000 or more, and more than 30 days overdue. Both have to hold. In F2, use one FILTER formula to list the invoice number, customer and amount (A:C) of every invoice in rows 2 to 9 that meets both conditions.

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.