Double entry problem

J

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
 
G

Gary's Student

Click the top of the list.
pulldown - Data > Filter > Advanced Filter
Check copy to another location and unique records only
 
Top