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

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT608-612.xlsm 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