How can I activate auto fill in a drop down list? My list of providers can be close to 2000 entries.......this could get quiet frustrating for customers trying to scroll through an entire list just to select a name.
How can I activate auto fill in a drop down list? My list of providers can be close to 2000 entries.......this could get quiet frustrating for customers trying to scroll through an entire list just to select a name.
Try this formula in data validation in G2:
Formula:Please Login or Register to view this content.
And in Data validation, select Error Alert tab and unmark box on top left that says something like "Show Error Alert...", then OK.
Copy cell G2 down to G7 to apply data validation to other cells.
Drop down list will show only those values that start with first characters typed.
Good luck!
Is there a way it could work to also index if criteria is inside the text string?
There may be some VBA solution to match and auto complete drop down list, and hopefully some VBA expert here will help you out.
To match criteria mid string, I would use a helper column, with this formula say in K2, which will spill down:
Formula:Please Login or Register to view this content.
Then, in Name Manager from the Formula ribbon, create a dynamic range named "Helper", for example, with this formula:
Formula:Please Login or Register to view this content.
Then in data validation, type:
=Helper
The problem with this solution, as you use multiple cells with data validation, each cell would require a new helper column and a new dynamic named range.
File attached with data validation in G2 only.
Happy trails!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks