Removing Duplicates

if I have a list of names and I want to remove the duplicate names. ie. If there is a duplicate I want both lines of the name removed so I am only left with the names that appear on the original list one time. How can I do that?

Attached doc has list with duplicates in column A.

Array formula in column B removes duplicated values between A2 and A500. Change formula ranges for a longer column A list.

Standard formula in column C relies on Helper formula in Column D to do the same as the array formula without the A2:A500 limit. You just need to ensure that both column C and D formulae are filled down to at least the same row as the last column A value.

Beau Nydal