11:57Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formulaexcelisfun10.2K viewsView & Download
7:31Excel Magic Trick 887: List Names In Tabular Table Twice: Row/Column or Column/Row Matchesexcelisfun2.9K viewsView & Download
5:07Excel Magic Trick 1217: D Functions: Text Criteria: “Starts With”, “Exact” and “Contains”excelisfun23.4K viewsView & Download
18:52Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & Moreexcelisfun12.6K viewsView & Download
5:33Excel Magic Trick 1093: Extract Date from Middle of Description: Text To Columns or Formula?excelisfun50.4K viewsView & Download
3:56Excel Magic Trick 1096: Extract Date from Middle of Description, Better Formulaexcelisfun10.7K viewsView & Download
2:27Excel Magic Trick 1187: Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functionsexcelisfun7.2K viewsView & Download
19:28Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chartexcelisfun10.7K viewsView & Download
5:58Excel Magic Trick 1193: Count Distinct Words As They Are Entered In Column: Formula or Excel Table?excelisfun11.5K viewsView & Download
9:16Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Testexcelisfun6.0K viewsView & Download
5:03Excel Magic Trick 311: Verify ID prefix w OR function 3 Examplesexcelisfun2.8K viewsView & Download
5:38Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Functionexcelisfun6.5K viewsView & Download
4:35Excel Magic Trick 1106: 3-D Gradient Conditional Formatting For Row with AND Criteriaexcelisfun7.1K viewsView & Download
6:55Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculationexcelisfun43.9K viewsView & Download
17:44Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)excelisfun51.6K viewsView & Download
4:31Excel Magic Trick 1113: Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, Pexcelisfun60.2K viewsView & Download
