text list

[Edson]

I have the following list:

AAA
AAA
AAA
XXX
XXX
BB
AAA
XXX
BB
BB
XXX

and I'd like to transform in this:
AAA
XXX
BB

in others words, I want to group all cells of a column by value in another
column. Any ideas?

 

[JE McGimpsey]

One way:

Select the column. Choose Data/Filter/Advanced Filter. Select Copy to
another location, and check the Unique items only, and select a location
to put your list.

 

[Edson]

It worked perfectly!

thx a lot

One way:

Select the column. Choose Data/Filter/Advanced Filter. Select Copy to
another location, and check the Unique items only, and select a location
to put your list.