Hide Duplicates in a Drop Down List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of a table I want to use a source for a drop down list
S3
S3
S4
S4
S4
S5
S5
S7
S8
I made a dropdown list using Data Validation. Is there a way to hide the
duplicates in the dropdown list? So my options are
S3
S4
S5
S7
S8
etc.
 
Couldn't you just use:
data|filter|advanced filter
to show the unique list and copy that to another column and use that?
 

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 Formula 3
Search multiple values & return single value - seperate worksheets 4
Vlookup / Match / Hlookup / Array fundtion or What? 5
DropDown List Custom Control 2
Lookups... 3
Dynamic RecordSet Field Name 4
Group and SUM 4
Data Errors When Calling Unmanaged VC6 DLL 2

Back
Top