filter unique data using functions

  • Thread starter Thread starter vrijbergen
  • Start date Start date
V

vrijbergen

Hello,

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

Thanks , Michie
 
You have one guess in .excel.
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
Click to expand...
 
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.
 
Back
Top