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.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of FILTER
0/3The same formula in the other shapes it takes at work.
- Show only the invoices that are actually overdue
FILTER keeps the rows where your condition holds.
CoreIntermediate - FILTER whole rows
Return every column of the matching rows, not just one.
Intermediate - FILTER driven by a cell
Point the condition at an input cell and the view changes when it does.
Intermediate
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 |
Functions used here
What this exercise teachesMay contain 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.