Learn about how to use FILTER function with a complex filter based on a BETWEEN, AND and OR Logical Tests. Chapter 13 in the book, The Only App That Matters. Learn about Advanced Filter also.
Download Excel File: https://excelisfun.net/files/EMT1841.xlsx
Topics:
1. (00:00) Introduction
2. (00:05) Complex Filter
3. (00:30) Logical Tests
4. (02:00) Filter Function
5. (06:02) Advanced Filter)
6. (07:54) Summary
7. (08:20) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup #filter #filterfunction #logical #advancedfilter