Eliminate ALL cells containing the same data

[GARY]

In Col A, cells contain:

AARDVARK
CAT
DOG
DOG
DOG
ELEPHANT
FISH
WOMBAT
WOMBAT
ZYGOTE

Clicking Data and Remove Duplicates results in:

AARDVARK
CAT
DOG
ELEPHANT
FISH
WOMBAT
ZYGOTE

Can Excel 2007 eliminate all cells containing the same data so the
result is:

AARDVARK
CAT
ELEPHANT
FISH
ZYGOTE

 

[Herbert Seidenberg]

Excel 2007 Tables
Strain one time items.
With Advanced Filter.
http://www.mediafire.com/file/f0ytmnoizhd/03_13_10.xlsx

 

[GARY]

Excel 2007 Tables
Strain one time items.
With Advanced Filter.http://www.mediafire.com/file/f0ytmnoizhd/03_13_10.xlsx

The mediafire link doesn't work. (Taking too long to respond)

 

[Herbert Seidenberg]

Excel 2007
Pdf preview:
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_13_10.pdf