Array Functions
Intermediate
Show only the invoices that are actually overdue
FILTER keeps the rows where your condition holds.
Task:
You are chasing payment and only want the invoices over 1,000. In E2, use FILTER to list the invoice numbers from A2:A8 where the amount in C2:C8 is greater than 1000.
Learning Objectives:
- Filter rows with a condition
- Write a comparison across a range
- Keep two ranges the same height
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Invoice | Customer | Amount | Chase these | |
| 2 | INV-201 | Alders Ltd | 1450 | ||
| 3 | INV-202 | Brant Co | 320 | ||
| 4 | INV-203 | Corvo SA | 2900 | ||
| 5 | INV-204 | Delta Group | 780 | ||
| 6 | INV-205 | Ekko BV | 1100 | ||
| 7 | INV-206 | Fenn Ltd | 450 | ||
| 8 | INV-207 | Gale Inc | 6300 |
What this exercise teaches (contains the answer)
This is what AutoFilter does, except it is live and it is a value you can feed into another formula. Change an amount and the chase list updates itself.