Eliminate ALL cells containing the same data

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match data duplicates 4
Custom Filtering more than 2 options 1
can I sort text data into bins? 5
2007 Formula Needed to Update Table Values 8
Lookup inquiry again 2
sorting cells based on another column/row 1
Excel tip 4
How to join 2 sumarised data sets 2

Top