Exercises / Modern Excel: dynamic arrays · 6 of 12
Show only one region
FILTER(range, include) returns the rows where include is TRUE. include is usually a comparison on one column, like B2:B13="North". The result spills and updates with the data.
Your taskIn F3, use FILTER to return every row of A2:C13 whose region is the one in G1.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Amount | Region | North | |||
| 2 | #3001 | North | $1,250.00 | Order | Region | Amount | ||
| 3 | #3002 | South | $480.00 | |||||
| 4 | #3003 | East | $2,210.00 | |||||
| 5 | #3004 | North | $760.00 | |||||
| 6 | #3005 | West | $1,890.00 | |||||
| 7 | #3006 | South | $3,120.00 | |||||
| 8 | #3007 | North | $2,475.00 | |||||
| 9 | #3008 | East | $395.00 | |||||
| 10 | #3009 | West | $1,040.00 | |||||
| 11 | #3010 | North | $1,985.00 | |||||
| 12 | #3011 | South | $1,500.00 | |||||
| 13 | #3012 | East | $820.00 |