Auto fill drop down boxes

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Is there a way to delete a name that appears twice in a
drop down auto fill box?
 
Hi Fred
This should not happen. Each item in the dropdown list should be unique.
What probably is the poroblem, is that some of 'apparently the same' entries, maybe have a space after the last character.
Try the Trim function on your data.
Yours,
Mathew
 
You must log in or register to reply here.

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

Auto fill not working 2
Drop down lists in excel 3
auto fill options (copy cell, not create series) 4
drop down list based on other drop down list pick 1
Expanded Drop Down Box Question 2
how to write a dependent validation with all numbers 1
Drop List Valadation and Auto Fill 3
auto fill or auto search from a list or drop-down list??????? 9

Back
Top