Data Validation dropdowns

Autocomplete Workaround for Validation Dropdowns

As might know there is no autocomplete functionality or any other features such as different font sizes with good old Data Validation cell dropdowns. On a client’s project I worked on today we really needed autocomplete capability. The dropdown list was 80 rows long and the values were messy to scroll through some with 3 …

Autocomplete Workaround for Validation Dropdowns Read More »

Dependent Dropdown using INDEX

Data Validation

Update 12/12/2021 Since writing this post in 2017, Excel now has new revolutionary dynamic array formulas that really has overtaken all the workarounds for better dropdown lists we used to do such as described in my post below. Now the new formula SORT() + UNIQUE() in Excel Office 365 (although not in earlier stand alone …

Dependent Dropdown using INDEX Read More »