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.