Data validation drop down

[isingal]

Hi friends

I have a list of countries that I have put in drop down by data validation. Need to provide an option that once someone starts typing the countries should be filtered based on alphabet and provide drop down alert.

Eg. If someone types 'A', all countries with alphabet A should be visible in drop down to select from and list should decrease with the spelling.

Isha

 

[Chrisdontm]

I think what you are wanting is described in this youtube video;

https://www.youtube.com/watch?v=tCahRfEGj1g