How do I delete duplicate entries?

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

Chris Mitchell

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.
 
Thanks Govind.

It's easy when you know how.

Govind said:
Hi,

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

Regards

Govind.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sliding scale for Mark Up 0
Excel Lookup 1
Creating Summary Worksheet 2
Validation List 2
Sort, simplify, duplicate rows and probably a few more steps! 0
comparing data in excel 3
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Sum Values from different column 1

Back
Top