Download Excel File: https://excelisfun.net/files/EMT1696.xlsx
Learn how to filter a table based on a list of values rather than one-by-one individual values. Amazing FILTER dynamic Spilled Array formula using XMATCH and ISNUMBER functions.
Topics:
1. (00:00) Introduction.
2. (00:24) XMATCH with function argument array operation to compare two lists.
3. (01:52) ISNUMBER to get TRUE and FALSE values for FILTER include argument.
4. (02:25) FILTER array function (lookup function too)!!!
5. (03:03) Formulas to use before FILTER function.
6. (03:18) Summary, Closing and Video Links