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?
|