Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free


See a formula that can lookup and return all the class periods based on the blanks in a different row using the functions COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL, COLUMN, and Concatenating (joining) two columns and an array formula.
Also see:
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods
Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers
Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations





Got a Question? Ask it Here in the Forum.