Main Profile

At A Glance

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
Length: 11:06

Contact

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

Want more info about Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question