Forum Discussion
Xeryar
Jan 31, 2022Brass Contributor
SEarch function in data validation list
Hi Team , I need to add a search function to my data validation list . I see options on youtube but I cant use the filter in FX . Is there a different way of doing it . I have 210 things in dropdow...
- Jan 31, 2022
Search is coming to Data Validation: see Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows
In the meantime, you can use a combo box, as in the attached version (Windows only)
mtarler
Jan 31, 2022Silver Contributor
Xeryar here is another option but maybe not as good as HansVogelaar ? I worked on it but was called away but figured I post anyhow. BTW, since you say you can't use FILTER does that mean you are NOT using Excel 365? Which version are you running? Just in case you just couldn't get FILTER to work I included it in the attached. I also included a macro based solution but that has some glitch with typing in the cell and immediately clicking the drop down.