Forum Discussion
MS Excel Flash Fill and Filtering Option with VBA .
Attached is an older example (Excel 97) with VBA.
You only need to type letters in the drop down box and it will show you all existing ones with those letters for you to select.
I'm not sure if this is exactly what you're looking for, but it might help.
Haven't tried it in Excel 365.
Hope I was able to help you with this file.
I know I don't know anything (Socrates)
Try a free Excel add-in called “Search deList”.
It works like this:
In any cell that has data validation (with List type) pressing ALT+RIGHT will open a searchable combobox.
Type some keywords to search, separated by a space, e.g "ma la"
The list will be narrowed down as you type.
Hit ENTER to sent the value to active cell.
You don't need VBA, so you can save your workbook as .xlsx.
It works on large data (tested on 100K rows)
You can find it here:
https://www.mrexcel.com/board/threads/i-created-an-excel-add-in-called-search-delist-to-create-searchable-data-validation.1189466/