Description
My boss kept breaking my spreadsheet, so I made tiny adjustments to the formulas and now they work like magic.
In this video, let me share 3 advanced FILTER() function tricks that can save you time and make you a PRO at work.
Trick 1: Using SEARCH with FILTER to make a multi-city search
Trick 2: Filtering based on any column (BYROW magic)
Trick 3: Operators in FILTER
Sample file: https://chandoo.org/wp/wp-content/uploads/2026/06/3-adv.-filter-tricks.xlsx
#filter #excel #formulas