UNIQUE: Distinct Lists, Distinct Counts and "Exactly Once"
This lesson is part of the course
In this lesson
You pull the distinct customers and teas from Lumen's order lines, count the customers with ROWS(UNIQUE()) and find the customers who ordered only once.
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