How do I delete duplicate entries?
 

I have a Column of data which contains a number of items, and contains some
of the items more than once, e.g.



Item 1

Item 2

Item 2

Item 2

Item 3



How can I get the contents into another column, such that each item only
appears once, e.g.



Item 1

Item 2

Item 3



I could manually delete the second and subsequent entries for each item, but
there must be a way of getting the machine to do this drudgery for me.



How can I do this?

Hi,

Use Data-Filter-Advanced Filter and choose unique entries only and
copy them to the location you want.

Regards

Govind.

Chris Mitchell wrote:
I have a Column of data which contains a number of items, and contains some
of the items more than once, e.g.



Item 1

Item 2

Item 2

Item 2

Item 3



How can I get the contents into another column, such that each item only
appears once, e.g.



Item 1

Item 2

Item 3



I could manually delete the second and subsequent entries for each item, but
there must be a way of getting the machine to do this drudgery for me.



How can I do this?

Thanks Govind.

It's easy when you know how.

"Govind" wrote in message
...
Hi,

Use Data-Filter-Advanced Filter and choose unique entries only and
copy them to the location you want.

Regards

Govind.

Chris Mitchell wrote:
I have a Column of data which contains a number of items, and contains
some
of the items more than once, e.g.



Item 1

Item 2

Item 2

Item 2

Item 3



How can I get the contents into another column, such that each item only
appears once, e.g.



Item 1

Item 2

Item 3



I could manually delete the second and subsequent entries for each item,
but
there must be a way of getting the machine to do this drudgery for me.



How can I do this?

Hi Chris,

Thanks for the feedback

Govind.

Chris Mitchell wrote:

Thanks Govind.

It's easy when you know how.

"Govind" wrote in message
...

Hi,

Use Data-Filter-Advanced Filter and choose unique entries only and
copy them to the location you want.

Regards

Govind.

Chris Mitchell wrote:

I have a Column of data which contains a number of items, and contains

some

of the items more than once, e.g.



Item 1

Item 2

Item 2

Item 2

Item 3



How can I get the contents into another column, such that each item only
appears once, e.g.



Item 1

Item 2

Item 3



I could manually delete the second and subsequent entries for each item,

but

there must be a way of getting the machine to do this drudgery for me.



How can I do this?