| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to eliminate duplicate entries | Excel Discussion (Misc queries) | |||
| I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
| Multiple Files, Duplicate Entries | Excel Discussion (Misc queries) | |||
| Add numbers for duplicate entries then delete | Excel Worksheet Functions | |||
| get count of row without duplicate entries | Excel Worksheet Functions | |||
Hybrid Mode
