Drop down dynamic search field displaying repeat choices from a unique list?

[tonyridino]

I've got a tool I built in excel - you type in a job you want to look up in the field, say Tax Analyst. The search bar shows all jobs that include the word Tax Analyst, i.e. Tax Analyst 1, Tax Analyst 2...etc all the way up to 6.

In this case, all I want is for it to return 6 entries total. However, its actually returning those 6 plus the rest of my data sheet as blank entries, PLUS repeat entries (got about 1000 rows of data here - all unique). So, my search results are gigantic and i don't want users to have this kind of mess.

Please look at my excel file for details. Type in Tax Analyst into the search bar and you'll see what i mean when you scroll down the drop down list using the down arrow.

Can anyone help me fix this?
Thanks

[HangMan]

If I type in 'Tax Analyst' I'm only seeing 6 entries in the drop down and also in column I, so not quite sure what the problem is, can you be more specific?

[tonyridino]

Yeah you'll see 6 entries. But click the down arrow scroll bar next to the 6 entries and you'll see empty space, duplicates and a whole lot of emptiness.
Make sense?

[ChemistB]

Like HangMan, I only see the 6 entries and no scroll bar. It appears to be working properly. What version of Excel are you using?

Edit: I reset a few times and now it is doing what you said it does. Not sure why yet.

[ChemistB]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[tonyridino]

GREAT!!
Thank you Chemistb!!

Can I ask what the rationale is?

[ChemistB]

This code

Please Login or Register  to view this content.

runs when you set the focus on the combo box. You do that when you click on it and begin typing. When you are done typing, the code does not run again (which is what you need it to do) unless you click outside the combo box and then back in.

Please Login or Register  to view this content.

runs when you hit enter after changing the contents of the box. That is when you need the code to run.