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

Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods Tube. Duration : 11.10 Mins.

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

Tags: Excel, 2007, 2010, Array, Formula, To, Return, Multiple, Items, functions, COUNTIF, IF, ROWS, INDEX, SMALL, ROW, excelisfun, Mike, Gel, Girvin, Highline, Community, College