Excel Dynamic Data Validation Lists | Data Management, Data Quality | Scoop.it
Create a data validation list that is dependent on another list using formulas that dynamically update when the source data changes.


Easy-to-use data validation. The formula is complex, but you can easily use the file! :-)

And there is a great trick with ! for advanced users :-)

Via Kris