copy each name only ones

[dubber]

hey

I've got a list of names

pete
anna
joh
daniel
pete
sue
...

and I want to make a new list which contains each name, but for example I don't want pete to appear twice...

[Special-K]

I'm sure there's a quicker way to do this but this should work:

Assuming names are in column A...

Sort the names
In B1 enter =IF(A2=A1,1,0) and copy the formula down the column
Select column B and copy and Paste Special values only
Now sort on column B
and delete the rows which have a 1 in column B which will be grouped together

[mdbct]

Highlight you column.
Goto Data / Filter > Advanced Filter...
Choose Copy to another location and specify the location in the "Copy To"
Check the Unique items only box.
Click Okay.