perfect.
thanks a lot to both of you!

"RichardSchollar" wrote:

Hi

Your easiest option to achieve this would be to use Advanced Filter -
Select your range (ie A1:A100 or whatever) and go DataFilterAdvanced
Filter. In the dialog that opens, select "Copy To Another Location",
check "Unique Records Only", and seletc a destination for your unique
records (eg B1).

Hope this helps!

Richard

On 30 Jan, 09:21, massi wrote:
I have a list with item repeated more than once:
item A
item A
item B
item B
item B
item C
item C

in the next column i would like to list all the items once only
item A
item B
item C

how can i do that?
rgds