4:31Excel Magic Trick 364: Return First Non-Blank (Array Formula)excelisfun18.6K viewsView & Download
5:17Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)excelisfun21.5K viewsView & Download
5:12Excel Magic Trick 363: Return Cell Address of First Non-Blankexcelisfun20.7K viewsView & Download
7:34Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formulaexcelisfun13.1K viewsView & Download
7:59Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formulaexcelisfun4.0K viewsView & Download
6:26Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magicexcelisfun20.3K viewsView & Download
6:01Excel Magic Trick 468: Count Spaces at Beginning & End of Text String (Array Formula)excelisfun4.3K viewsView & Download
17:18Excel Magic Trick 1271: Extract Top 20 Values & Dates: Formula, Array Formula or Power Query?excelisfun36.9K viewsView & Download
11:06Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periodsexcelisfun57.7K viewsView & Download
8:32Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterionexcelisfun15.9K viewsView & Download
8:24Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formulaexcelisfun79.1K viewsView & Download
11:53Excel Magic Trick 458: OR and AND criteria Together In Data Extract Array Formula Boolean Logic Mathexcelisfun4.2K viewsView & Download
11:57Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formulaexcelisfun10.2K viewsView & Download
9:16Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Testexcelisfun6.0K viewsView & Download
18:09Excel Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groupsexcelisfun6.1K viewsView & Download
3:47Excel Magic Trick 901: Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cellexcelisfun35.2K viewsView & Download
12:59Excel Magic Trick 1110: Compare 2 Lists and Extract Records: Array Formula Methodexcelisfun33.5K viewsView & Download
11:31Excel Magic Trick 784: Empty Cells OR Formula Created Blank: Confusion Over Word "Blank"excelisfun37.6K viewsView & Download