customize drop-down box

A

Art

Is there a way to use Data Validation to create an in-cell drop-down box from
a range of cells...but before displaying that list in the drop-down box, can
you

(1) remove duplicate values (e.g., names)
(2) alphabetize the list

I have a list of instructors I want to automatically appear in the drop-down
box, but the range the drop-down box draws from contains duplicate instructor
names, and the names are not alphabetized.

Thanks!
 

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

Dependent drop down dynamic range formula, off sheet. 7
How do I create a drop down box within a drop down box? 1
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
data validation fonts differ in drop down box 1
drop down box code 2
How do you select multiple characters in a drop down list to appe. 2
excel 2003 drop-down box color changes how 2

Top