As might know there is no autocomplete functionality with Data Validation dropdowns. I wonder if the Microsoft development teams are considering this as it would be a wonderful feature. I sometimes wonder if the validation dropdown was an accidental dropdown…
Tag: Data Validation dropdowns
Autocomplete Workaround for Validation Dropdowns
Tagged with: autocomplete, Comboboxes, Contextures, Data Validation dropdowns, Debra Dalgleish, dynamic formulas
Dependent Dropdown using INDEX
Data Validation Dependent Dropdowns are important practical feature to make your spreadsheets more usable and robust. Data Validation Dependent Dropdowns are dropdowns which change according to a another dropdown choice. For example if I have a data set with say…
Top