Photo Gallery

OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912
Excel FILTER Function - Meet ONE Condition ONLY - Strict OR Logic
Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)
Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913
OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645
IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation?  EMT 1746
FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843
Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819
Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750
Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832