DYNAMIC ARRAYS · ORIGINAL EXERCISE
The northern manifest
Return all six columns of A2:F9 for orders whose region in B2:B9 equals "North". Return "None" if nothing matches.
This quest practices FILTER rows 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
- FILTER takes the result array and a matching include test.
- Compare every region cell with "North".
- Use "None" as the optional empty result.
Show the worked solution
=FILTER(A2:F9,B2:B9="North","None")The comparison produces a column of TRUE/FALSE values. FILTER returns each full row whose test is true.
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 →