Making a list formula

[J Donahue]

I have a list of employees. The problem is that the
source that the list has come from has caused people to be
listed more than once on the list.

Is there a formula I can use and copy down that will
create a list of employees from this list but with no
repeat employees.

Example below

John Smith
Jack Donovan
Sheila Walsh
Jill Pierce
Joanne Wells
Jack Donovan
Jill Pierce
John Smith
Bob Newhart

I would like to get a formula I can copy down another
column that would produce a list of these employees with
no repeats so the result from the above list would be

John Smith
Jack Donovan
Sheila Walsh
Jill Pierce
Joanne Wells
Bob Newhart

so that the repeats are not picked up.

Any help is appreciated

Thanks in advance

J Donahue

and the second

 

[Peo Sjoblom]

Use data>advanced filter, copy to another location and unique records only