FILTER: Criteria Cells, AND / OR Conditions and "If Empty"
This lesson is part of the course
In this lesson
You extract Lumen's orders for one region, then combine conditions with AND (*) and OR (+), and show a friendly message when nothing matches.
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