2:18Excel Magic Trick 643: IF Function to Pull Data From A Different Columnexcelisfun497.9K viewsView & Download
7:23Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)excelisfun70.1K viewsView & Download
2:38Excel Magic Trick 605: IF Function to Fill In Column With Missing Values Paste Special Valuesexcelisfun22.4K viewsView & Download
5:33Excel Magic Trick 1093: Extract Date from Middle of Description: Text To Columns or Formula?excelisfun50.4K viewsView & Download
4:31Excel Magic Trick 1113: Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, Pexcelisfun60.2K viewsView & Download
4:58Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!excelisfun55.4K viewsView & Download
12:46Excel Magic Trick 849: Extract Records For Week With Formula that works in Excel 2003, 2007, 2010excelisfun11.3K viewsView & Download
6:46Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)excelisfun12.4K viewsView & Download
8:49Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.excelisfun11.8K viewsView & Download
7:40Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Recordsexcelisfun12.2K viewsView & Download
4:09Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functionsexcelisfun7.5K viewsView & Download
11:46Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query?excelisfun6.5K viewsView & Download
2:28Excel Magic Trick 1018: CEILING Function To Round Up To The Nearest $1000 Incrementexcelisfun11.8K viewsView & Download
8:24Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formulaexcelisfun79.1K viewsView & Download
11:36Excel Magic Trick 946: Is Item In List NOT In Any Other List? (Check Against 3 Other Columns)excelisfun9.2K viewsView & Download
2:45Extract All Digits from Range & List in Column - Excel Magic Trick 1812 #shortsexcelisfun7.6K viewsView & Download
4:52Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716excelisfun15.9K viewsView & Download
9:49Excel Magic Trick 1136: Correlation From 4 Columns: CHOOSE Array Formula “Mash” Columns Togetherexcelisfun11.2K viewsView & Download
