8:37Excel Magic Trick 622: Array Formula to Return Even Row Data Onlyexcelisfun5.6K viewsView & Download
2:52Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2excelisfun192.7K viewsView & Download
11:06Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periodsexcelisfun57.7K viewsView & Download
13:54Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Freeexcelisfun17.2K viewsView & Download
3:31Excel time saver: Select every odd row (or all even rows) - Doctor Excel #086Doctor Excel47.7K viewsView & Download
2:31Excel Magic Trick 632: Count Dates Within Given Year From A List Of Dates With Different Yearsexcelisfun6.1K viewsView & Download
3:53Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Functionexcelisfun31.0K viewsView & Download
6:55Excel Magic Trick 465: Lookup Entire Row (ALL COLUMNS) with INDEX for Cake Manufacturing Calculationexcelisfun43.9K viewsView & Download
8:21Excel Magic Trick 1502: Lookup Based On Row Number with Data Validation For Row Numberexcelisfun15.3K viewsView & Download
8:24Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formulaexcelisfun79.1K viewsView & Download
13:37Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)excelisfun27.6K viewsView & Download
2:50Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Yearsexcelisfun10.1K viewsView & Download