Hi

One way
Insert a row above your data. Type in a Header e.g. List
Mark the block of data including header, then
DataFilterAdvanced FilterCopy to choose your next columnclick
Unique items

--
Regards

Roger Govier


"massi" wrote in message
...
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