Select a cell within the list, then Data/Filter/Advanced filter, and select
Unique records. If this is only one column in your "list", then you should
select just this column before you do the filter.

On Mon, 3 Oct 2005 11:09:47 -0500, vrijbergen
wrote:


Hello,

I have the following problem: I have many column's containing
text-numbers (example ABC-1D54-59D) and I want to filter in such a way
that only unique values remain per column. How can I do this, I already
used the data-filer of excel.

Thanks , Michiel