Excel Forum



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.





Got a Question? Ask it Here in the Forum.