Level 3Formulas That SpillPractice, 3 min
SORT a FILTER
The task
The West team wants its deals, biggest first. In F2, FILTER the whole table to West, then SORT the result by Amount (its 4th column), descending.
The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Deal | Rep | Region | Amount | Deal | Rep | Region | Amount | |
| 2 | Northwind | Maya | West | $18,500 | |||||
| 3 | Cobalt Labs | Theo | East | $7,200 | |||||
| 4 | Brightline | Priya | West | $9,400 | |||||
| 5 | Fieldstone | Jonah | Central | $22,800 | |||||
| 6 | Harbor & Co | Lena | East | $13,100 | |||||
| 7 | Quillworks | Maya | West | $11,250 | |||||
| 8 | Ridgeview | Theo | Central | $5,600 | |||||
| 9 | Summit Bank | Priya | West | $26,400 |