Excel Forum



Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods


See a formula that can lookup and return all the student names based on the blanks in a different column using the functions COUNTIF, IF, ROWS, INDEX, SMALL, ROW 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 609: Array Formula To Return Multiple Items - List Periods That Students Have Free
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.