Drop Down lists

H

haas786

Hey all,

I have a drop down list which contains names of 3,200+ companies. I
used the menu option Data, Validation, and Allow List and point to
cell AP2:AP3225 for the company list. Now, is there any way for me to
type in the first few letters of the company name in the drop down
list to allow that company (or companies) to appear first.

For example, I'm looking for Prudential, I'll type Pru, and the drop
down list will start at the first entry for Pru on the list. I hope I
was clear in this explanation. Please help - if further clarification
is needed, please let me know.

Thanks in advance...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL DROP DOWN 2
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Pick from drop-down list gives empty or erroneous result 6
Drop Down Lists 1
Drop Down List Format 2
Help with external drop down lists 5
drop down list accessed by typing the first few letters 4
Excel Excel: How do I put a formula in a drop down list 11

Top