My Data Validatio drop down has 30,000 rows. I need to do the following

1.Increase the number of rows shown from 8 to 50
2.Allow users to type in the drop down to filter their search. For example
when they are in the drop down and type "B" it brings up those list choices
that start with "B".

Any help is greatly appreciated