Remove Duplicates in an Array

[Patrick]

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

 

[Bernd]

Hello,

I suggest to take only the first column of the result array of my UDF
lfreq:
http://www.sulprobil.com/html/listfreq.html

Or you write a similar function on your own.

Regards,
Bernd

 

[Tom Ogilvy]

http://j-walk.com/ss/excel/tips/tip47.htm

 

[Patrick]

Many thanks Tom for the link, i will give it a look.

Patrick

 

[Patrick]

Many thanks Bernd. I will give your code a look.

Patrick.