Couldn't you just use:
data|filter|advanced filter
to show the unique list and copy that to another column and use that?



Sloth wrote:

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.

--

Dave Peterson