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
|