10:15Advanced Formula Magic: Running total by row with dynamic arrays in ExcelExcel Off The Grid19.7K viewsView & Download
7:34Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formulaexcelisfun13.1K viewsView & Download
4:513 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)Leila Gharani1.0M viewsView & Download
3:11Excel Magic Trick 460: Transpose Range with INDEX, COLUMNS and ROWS functionsexcelisfun89.4K viewsView & Download
1:21Excel Magic Trick 444: Multiply Column Times Row With TRANSPOSE Functionexcelisfun78.8K viewsView & Download
15:51Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Dataexcelisfun14.5K viewsView & Download
1:10:10Excel Dynamic Spilled Array Formulas & Functions: 50 Examples to Become an Expert! - 365 MECS 09excelisfun65.3K viewsView & Download
39:40Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)excelisfun92.7K viewsView & Download
8:05Excel 2010 Magic Trick 796: Excel Flip Table Rotate Table TRANSPOSE or INDEX or Paste Specialexcelisfun42.5K viewsView & Download