DYNAMIC ARRAYS · ORIGINAL EXERCISE
Two seals for entry
Return A2:F9 rows for North orders with at least 10 units. Return "None" if none match. Use FILTER with both conditions.
This quest practices FILTER with AND using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.
| Order | Region | Product | Units | Revenue | Cost |
|---|---|---|---|---|---|
| O-101 | North | Keyboard | 12 | 720 | 420 |
| O-102 | South | Mouse | 18 | 450 | 198 |
| O-103 | North | Monitor | 5 | 1250 | 900 |
| O-104 | West | Keyboard | 8 | 480 | 280 |
| O-105 | South | Monitor | 4 | 1000 | 720 |
| O-106 | North | Mouse | 20 | 500 | 220 |
| O-107 | West | Monitor | 6 | 1500 | 1080 |
| O-108 | East | Dock | 10 | 600 | 350 |
Hints to get you started
- Each condition produces an array of logical values.
- Multiplication makes a row eligible only when both conditions are true.
- Parenthesize each comparison before multiplying.
Show the worked solution
=FILTER(A2:F9,(B2:B9="North")*(D2:D9>=10),"None")Multiplying array tests acts like row-by-row AND because TRUE becomes 1 and FALSE becomes 0.
Make the skill stick
After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.
Explore the rest of this region →