8:53Excel Magic Trick 1211: Array Operations on Different Size Arrays & CHISQ.TEST Functionexcelisfun9.8K viewsView & Download
14:11Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication?excelisfun18.7K viewsView & Download
1:50XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611excelisfun40.7K viewsView & Download
15:08Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEXexcelisfun26.5K viewsView & Download
12:59Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Methodexcelisfun33.5K viewsView & Download
7:12Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trickexcelisfun8.1K viewsView & Download
9:16Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Testexcelisfun6.0K viewsView & Download
8:57Excel Magic Trick 1224: Which Similar Array Formula? Compare Number of Array Operationsexcelisfun2.9K viewsView & Download
1:10:10Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09excelisfun65.5K viewsView & Download
3:04Spilled Array Formulas Make Excel Life Easy. Compare Two Lists Extract Items Excel Magic Trick 1750excelisfun32.8K viewsView & Download
6:58Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methodsexcelisfun24.6K viewsView & Download
5:11Excel Magic Trick 1111: Item In Both Lists? Extract With Better Array Formulaexcelisfun9.1K viewsView & Download
15:08Excel Magic Trick 1009 Lookup 3 Different Arrays From 3 Different Tables VLOOKUP, CHOOSE, INDEXAk Cricket0 viewsView & Download
22:03Excel Magic Trick 1073: Excel Tables & Dynamic Data Extraction Array Formulas, AGGREGATE or SMALLexcelisfun34.9K viewsView & Download
5:23Excel Magic Trick 1186: Extract Color From Description Field & Create Revenue by Color PivotTableexcelisfun7.7K viewsView & Download
12:21Excel Magic Trick 1462: 5,000 Formulas in a Single Cell with SUMPRODUCT or Array Formula?excelisfun13.9K viewsView & Download
11:57Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formulaexcelisfun10.2K viewsView & Download
7:37Excel Magic Trick 1042 Array Functions Housed In Other Functions Usually Don't Need Ctrl Shift Enterexcelisfun4.8K viewsView & Download