VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)

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

Excel FILTER based on list, not individual values? Easy! Excel Magic Trick 1696.

Excel FILTER Function with Partial Text Criteria or Contains Criteria. Extracting Records. EMT 1653

Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.

OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743

One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591

Two Lookup Values for Excel Lookup? FILTER or INDEX? - Excel Magic Trick 1590

Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits

Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).

FILTERXML Function to Split Text into Cells. Excel Magic Trick 1685.

OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697.

IF, FILTER, SUMIFS or COUNTIFS for OR Logical Test Aggregate Calculation? EMT 1746

Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748

Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750

Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752

Extract Records For Invoices 1 to 30 Days Past Due – Dynamic Excel Formula Method - EMT 1776

XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791

Unique List of Case Sensitive Items? Expandable Range in Spilled Array Formula? EMT 1792

FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801

Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811

Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819

Format Total Row in Dynamic Spilled Array (Conditional Formatting) # Short Excel Magic Trick 02

Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820

Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822

FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837

Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function?

Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836

Lookup Multiplying For Commission Calculation: FILTER, XLOOKUP, LAMBDA & BYROW. EMT 1838.

FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841

FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842

FILTER Function to Extract Records by Area Code. Excel Magic Trick 1843

Filter Feature CANNOT run an OR Logical Test Across Two Columns: 2 Solutions. Excel Magic Trick 1847

BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871

FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874

Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899