Forum Discussion
Predictive text in an Excel drop down list
How do I get predictive text in a drop down list ? Life would be so much quicker rather than scrolling ....
It works natively for Excel Online. For other editions there are some workarounds, but they are quite limited, you may google something like "excel searchable drop-down list". and it depends on which Excel you are.
There is a reason for the blanks. They correlate with other calculations that can be dragged. But searching the internet found this formula.
=FILTER(C2:C32,ISNUMBER(SEARCH('RWk43'!E4,C2:C32)),"Not Found")
This I place in D3 of the Staff tab and then change the data validation source to just Staff!D3# ...
When in the roster I can now type a couple of letters and hit the drop down and hey presto ! there are the names related to those letters. Not predictive but real close🙂
Thank you for your input it is greatly appreciated
