filter unique data using functions
 

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


--
vrijbergen
------------------------------------------------------------------------
vrijbergen's Profile: http://www.excelforum.com/member.php...o&userid=27757
View this thread: http://www.excelforum.com/showthread...hreadid=472675

You have one guess in .excel.

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

--
vrijbergen
------------------------------------------------------------------------
vrijbergen's Profile: http://www.excelforum.com/member.php...o&userid=27757
View this thread: http://www.excelforum.com/showthread...hreadid=472675

--

Dave Peterson

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