Members lesson 20
Dynamic arrays project
Build a live order summary with calculated, distinct, filtered, and sorted results.
What you will practice
- Calculate a blank-safe total column
- Sort a distinct list
- Build a ranked summary with FILTER and SORT
Lesson preview
Starting tableOrder summary
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Owner | Category | Units | Rate | Status | Total | Categories | Sorted categories | ||
| 2 | Ana | Office | 3 | 20 | Open | |||||
| 3 | Bo | Travel | 2 | 80 | Open | |||||
| 4 | Cam | Office | 5 | 12 | Closed | |||||
| 5 | Dee | Events | 4 | 45 | Open | |||||
| 6 | Eli | Travel | 1 | 120 | Open | Open work by rate | ||||
| 7 | Fay | Office | 6 | 10 | Closed | |||||
| 8 |