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

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

Use data-Filter-AdvanceFilter ,
Give the destination range and check unique records





--
Thanks
Xcelion



"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

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

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

if i don't include the header the first item is repeated twice. am i doing
something wrong?




"Roger Govier" wrote:

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

No, that's what happens if the list does not have a header.
Put a header in, even if you delete the row after you have carried out
the Advanced Filter.

--
Regards

Roger Govier


"massi" wrote in message
...
if i don't include the header the first item is repeated twice. am i
doing
something wrong?




"Roger Govier" wrote:

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

ok.
will do
thanks

"Roger Govier" wrote:

No, that's what happens if the list does not have a header.
Put a header in, even if you delete the row after you have carried out
the Advanced Filter.

--
Regards

Roger Govier


"massi" wrote in message
...
if i don't include the header the first item is repeated twice. am i
doing
something wrong?




"Roger Govier" wrote:

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