Completed
INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Dynamic Spilled Array Formulas and Functions - Revolution in Easier Worksheet Solutions
Automatically move to the next video in the Classroom when playback concludes
- 1 Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09
- 2 Filter by rows and columns: Excel Formula for Any Version of Excel! Excel Magic Trick 1752
- 3 Excel 365 Basics #7: Comprehensive Formula & Function Lesson To Become An Excel Formula Guru!
- 4 MS 365 Excel Basics #10 Part 04: GROUPBY Array Function to Calculate the Percent of Count Total
- 5 MS 365 Excel Basics #10 Part 02: SORT Array Function & the Many Varied Tasks It Can Achieve!
- 6 MS 365 Excel Basics 09: PIVOTBY & GROUPBY Functions Beat PivotTable: 10 Mind-Blowing Examples!
- 7 Excel 365 Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!
- 8 Excel 365 Basics #5: IF Function & Logical Tests IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
- 9 DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.
- 10 Append Tables in Excel. Excel Magic Trick 1852
- 11 Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10
- 12 ETA-LAMBDAs for BYROW, BYCOL & SCAN to Make Spilling Row Totals & Running Totals Easy. EMT 1846
- 13 FILTER Function with List of Partial Text Contains Criteria & Not Contains Criteria. EMT 1837
- 14 Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21
- 15 Excel FILTER Function to Extract Records Based on Items in a List. Excel Magic Trick 1820
- 16 Joint Probability Tables: How To Create & Use Them (Not Just For Statisticians!) EMT 1818
- 17 VSTACK & 3-D References: Combine Worksheet Data into One Table!!!! Excel Magic Trick 1786
- 18 TOCOL, DROP, EXPAND Array Functions to UnPivot Data into Proper Table. Excel Magic Trick 1785
- 19 WRAPCOL & SORTBY Array Functions to Pivot A Table. "Robustify" your formulas! Excel Magic Trick 1784
- 20 Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750
- 21 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716
- 22 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683.
- 23 Double OR Logical Tests in SUMIFS Function using FILTER or IF or MMULT. Excel Magic Trick 1669.
- 24 INDEX & MATCH or XLOOKUP for Lookup Formula in SUMIFS Criteria Argument. Excel Magic Trick 1668.
- 25 Excel Formula for Number of Bills for Money Transaction? Dynamic Spilled Array Formula? EMT 1898
- 26 Excel Formula to Create Inventory Reorder List from Multiple Tables. VSTACK & FILTER Fun! EMT 1899
- 27 COUNTIFS, GROUPBY & LET Functions: Create Amazing Single Cell Dynamic Spilled Array Report. EMT 1901
- 28 The Magic of Excel’s REDUCE & LAMBDA Functions to Split Values & Spill an Array of Arrays! EMT 1908
- 29 Excel Formula Creates Unique List with “ALL” at Top! VSTACK, UNIQUE & SORT Array Functions EMT 1909
- 30 FILTER function AND Logical Test made Easy with BYROW & AND functions! Excel Magic Trick 1912
- 31 Amazing BYROW Function in FILTER Function Make Dynamic Filtering by OR Logical Test Easy! EMT 1913
- 32 2 Excel Formulas to Add Sequential Numbers Each Time a New Row Is Added To a Table. EMT 1915
