SORT & SORTBY: Largest First, Two Sort Keys and Custom Orders
This lesson is part of the course
In this lesson
You sort Lumen's customer list by revenue, by region and revenue at once, by a key that is not in the output (average order value) and by a custom region order.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Spill Basics: One Formula, Many Cells, and the #SPILL! Error Locked
- SORT & SORTBY: Largest First, Two Sort Keys and Custom Orders Locked
- FILTER: Criteria Cells, AND / OR Conditions and "If Empty" Locked
- UNIQUE: Distinct Lists, Distinct Counts and "Exactly Once" Locked
- SEQUENCE: Numbering, Date Series and a Monthly Calendar Locked
- Spill References (A1#): A Region Summary That Grows by Itself Locked
- Report Building: VSTACK, DROP, CHOOSECOLS, TAKE and HSTACK Locked
- Capstone: A Dynamic Top-N Dashboard with a Chart Locked