FILTER practice exercises
Returns only the rows that meet a condition. The result spills. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 3701 | East | Theo | 6 | 12 | 72 |
| 3 | 3702 | West | Ines | 6 | 45 | 270 |
| 4 | 3703 | West | Ines | 3 | 15 | 45 |
| 5 | 3704 | South | Ana | 1 | 24 | 24 |
| 6 | 3705 | West | Theo | 8 | 15 | 120 |
| 7 | 3706 | North | Theo | 3 | 18 | 54 |
| 8 | 3707 | South | Maya | 7 | 9 | 63 |
| 9 | 3708 | North | Maya | 2 | 60 | 120 |
List the Order numbers from East. Your formula spills down from H2.
Show answer
=FILTER(A2:A9,B2:B9="East")→ 3701List the Order numbers from South. Your formula spills down from H2.
Show answer
=FILTER(A2:A9,B2:B9="South")→ 3704, 3707List the Order numbers from West. Your formula spills down from H2.
Show answer
=FILTER(A2:A9,B2:B9="West")→ 3702, 3703, 3705List the Order numbers from North. Your formula spills down from H2.
Show answer
=FILTER(A2:A9,B2:B9="North")→ 3706, 3708
New to FILTER? Read the FILTER guide first: syntax, a worked example and common mistakes.