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

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

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

--
Regards,
Tom Ogilvy


"Patrick" wrote:

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

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

Patrick

"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"Patrick" wrote:

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

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

Patrick.

"Bernd" wrote:

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