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: dynamic formulas
Autocomplete Workaround for Validation Dropdowns
Tagged with: autocomplete, Comboboxes, Contextures, Data Validation dropdowns, Debra Dalgleish, dynamic formulas
Validation Dropdown lists based on Table Columns ranges
Up until quite recent versions of Excel (I am guessing a little here because I only have Office 365 so always have the latest and forget when I discovered this) if you wanted a dynamic list for your Validation Dropdowns,…
Top