HomeОбразованиеRelated VideosMore From: ExcelIsFun

Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)

193 ratings | 4533 views
Download Excel File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1529.xlsx This video teaches all about AND Logical tests and OR Logical Test and the intricacies of how to construct and use them in Excel, including single cell logical Test sand Array Logical tests. It also examines how Excel Functions and Features interprets FALSE and 0 (zero) as FALSE and TRUE and Any Non-Zero Number as a TRUE. Then we take the lessons of Logical tests and Apply them in Various ways in the FILTER ARRAY Function. We also get to see a great trick from Peter Bartholomew about how to create a shorter formula than the one as seen in Excel Magic Trick 1521. We also entertain a question from John Borg about an OR Logical Test inside the FILTER Function. Reference video about FILTER Function EMT 1521: https://www.youtube.com/watch?v=5zRab2Grz7Q Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516): https://www.youtube.com/watch?v=7jJMDGZpjSk
Html code for embedding videos on your blog
Text Comments ()

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.