Members lesson 18
SORT
Sort a spilled table by one column, descending order, and two keys.
What you will practice
- Sort a complete table by one column
- Use FALSE for descending order
- Apply a second key to break ties
Lesson preview
Starting tableTeam scores
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Team | Score | Priority | Score ascending | Team, then score | ||||
| 2 | Operations | 88 | High | ||||||
| 3 | Sales | 92 | Low | ||||||
| 4 | Operations | 76 | Medium | ||||||
| 5 | Finance | 92 | High | ||||||
| 6 | Sales | 81 | Medium | ||||||
| 7 | Finance | 76 | Low | ||||||
| 8 | Score descending | Score, then team |