Previous Topic Next Topic

How to deal cells with same content except on

Closed
Myrcka - Jul 13, 2009 at 07:48 AM
 Trowa - Jul 13, 2009 at 08:24 AM
Hello,
hey i got lots of data in the B collum a lot of the data is the same, repeated in row after row but not all data is the same. waht i have tried to figure out how to do for a long time is: how do i delete all the cells that contain the same data except one. i will give an exempel:

abc
abc
abc
cba
cba
cba
dac
dac
dac

is gonna end up looking like this :

abc

cba

dac

hope this is understandable

thanks for any help
(sorry for bad language typos etc)
Related:

1 response

Answer 1 / 1
Trowa
Jul 13, 2009 at 08:24 AM
Hi Mircka,

What you want is easely done by the filter option in excel:
First select the data you want to filter.
Now choose the Data menu, click Filter, then click Advanced filter.
In this menu you can choose to only show the unique entries and even copy
them to a different location.

Hope this will help you out.

Best regards,
Trowa
1