|
Featured Tutorial
Featured Macro
Excel Magic Trick #241: Data Validation w Shrinking List
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.