Exercises / Modern Excel: dynamic arrays · 8 of 12
Filter for one region or another
Adding conditions gives OR: (A2:A9="East")+(A2:A9="West") is at least 1 when either is TRUE, and FILTER keeps every row that is not 0.
Your taskIn E2, use FILTER to list the order numbers in A2:A13 whose region is either G1 or G2.
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 |
|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Amount | Orders | Region 1 | North | |
| 2 | #3001 | North | $1,250.00 | Region 2 | East | ||
| 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 |