Removing Multiple Entries

I need remove duplicate entries from an Excel spreadsheet of 11K records. However, I don't need just to filter the list. If there are duplicate (or triple) entries, I need to remove the identical rows. For example:

Apples
Apples
Apples
Orange
Banana
Grape
Grape

I'd need to remove all occurrences of Apples and all occurrences of Grape.

Any ideas?

hi,
if you are using office 2010 and want to remove all occurrences of apples and grape if it repeats then as I understand from above example you would have only orange and banana.
In that case you could select the column you want check for and do Home>conditional formatting>new rule>format only unique and duplicate values
this would hilite only the values repeating and then you can filter on fill color and remove rows
if scenario is little different then please post back

It worked! Thank you!