Hi,
I have a worksheet where double entries occur, e.g.
Colum A
Smith
Smith
Jones
Andy
Smith
Andy
How can I make a routine that sorts out only the unique entries in a new
colum, e.g.
Colum B
Smith
Jones
Andy
Thanks,
Jesper Perregaard
Hi,
I have a worksheet where double entries occur, e.g.
Colum A
Smith
Smith
Jones
Andy
Smith
Andy
How can I make a routine that sorts out only the unique entries in a new
colum, e.g.
Colum B
Smith
Jones
Andy
Thanks,
Jesper Perregaard
Click the top of the list.
pulldown - Data > Filter > Advanced Filter
Check copy to another location and unique records only
--
Gary's Student
"Jesper Perregaard" wrote:
> Hi,
>
> I have a worksheet where double entries occur, e.g.
>
> Colum A
>
> Smith
> Smith
> Jones
> Andy
> Smith
> Andy
>
> How can I make a routine that sorts out only the unique entries in a new
> colum, e.g.
>
> Colum B
>
> Smith
> Jones
> Andy
>
> Thanks,
>
> Jesper Perregaard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks