Autocomplete Date Validation List drop-down

Hi,
I got a huge list of Names in my data validation list drop-down. Is there any way to use autocomplete just to save some time? For example, if user types P in the cell, it will show a list of names starting with P and then narrows down as more letters are typed.

I do not want to use a combobox, since there are hundreds of cells with these in-cell data validation list drop-downs.

Thanks

Natively, no.
You can add the entire list of names in hidden rows above the DV cells so that the usual autocomplete kicks in, or you can use a control (or a form that pops up when you select a cell with a DV list) or if you really want some fun, you can try and implement this.
Another alternative, albeit clunky, is to use something like the attached which filters the cell based on typed values, so you type one or two letters and then use the dropdown to complete.