I have a list of values in a column on an spreadsheet which i want to use to
populate a dropdown. The problem is that there are duplicate values in the
column and I only want to use unique values. I can transfer this informatin
to an Array but have become stuck on how to remove duplicate entries.

Do i have to step through the column and only write each occurrence of a new
value to the Array or is there a quick way to remove duplicate values from
the Array?

Any advice or help would be greatly appreciated.

Thanks