Members lesson 19
SORT and FILTER together
Filter a table, sort the matches, and surface the strongest results first.
What you will practice
- Place FILTER inside SORT
- Rank only rows that meet a condition
- Surface top results with two filter tests
Lesson preview
Starting tableProject scores
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Project | Region | Score | Status | Active projects | |
| 2 | Alpha | North | 84 | Active | ||
| 3 | Beta | South | 91 | Active | ||
| 4 | Gamma | North | 72 | Paused | ||
| 5 | Delta | West | 88 | Active | ||
| 6 | Echo | North | 95 | Active | ||
| 7 | Foxtrot | South | 79 | Paused | ||
| 8 | Grove | West | 82 | Active | Active by score |