Completed
10. 11:42 Summary
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
FILTER Function and Logical Test Made Easy with BYROW and AND Functions - Excel Magic Trick 1912
Automatically move to the next video in the Classroom when playback concludes
- 1 1. 00:00 Introduction.
- 2 2. 00:48 Goal of video: Use FILTER function to dynamically extract records from a data set based on an AND Logical Test.
- 3 3. 01:10 What is an AND Logical Test?
- 4 4. 02:14 Solution #1: AND Function in Helper Column. Why the AND function can’t be used in the FILTER function.
- 5 5. 04:36 Solution #2: Direct AND Logical Test Dynamic Spilled Array Formula using the multiplication math operator inside FILTER function.
- 6 6. 07:43 Using results from AND function helper column in the FILTER function.
- 7 7. 08:07 Solution #3: BYROW and AND function to shorten the formula element that is required in the FILTER function.
- 8 8. 10:01 Change conditions to check if formulas work.
- 9 9. 10:16 Bonus: Conditionally Formatting the dynamic result with Conditional Formatting.
- 10 10. 11:42 Summary
- 11 11. 11:56 Closing
