Excel Magic Trick #241: Data Validation w Shrinking List

Download Excel Start File: h https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT233-245.xls Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT233-245Finished.xls Full Page With All File Links: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT221-229Finished.xls See how to create Data Validation Drop Down Cell List where the List shrinks as you select values. See array formulas, INDEX function formula with criteria, data validation and the OFFSET function used in a named formula that creates a dynamic range of cells.