I have a list of countries like which I am binding to list in worksheet:
# Auto-complete functionality, when user type lets say afg , 'Afghanistan' comes automatically, similarly when user type 'den' 'denmark' appears.
# Auto-search functionality, when user type 'D' in the drop-down all values starting with 'D' should appear so that user can select.
Enclosing sample excel fyr.
Hopefully looking forward to hearing from you.