Formula for Listing Unique Values from a Separate Column Containing Duplicates

Hi,

I'm hoping to have a formula that I can drag down which lists unique occurrences in a column with duplicates.

For instance, if a column listed the below:

FRUIT
apple
kiwi
orange
apple
banana
kiwi
kiwi
grape
banana
banana
apple
apple
orange
grape
kiwi

I'd like to have a formula that returned the below:

FRUIT
apple
orange
banana
grape
kiwi

...and return blank values (or a specified value via the use of quotation marks) for all rows under 'kiwi' that the formula is dragged down to

Is this possible?

Thank you!

nevermind:
http://www.globaliconnect.com/excel/...=77&Itemid=473

Hi,

for that, you can use ( ADVANCED FILTER) .... there you mark (UNIQUE VALUE ONLY).... this is easy way to do that...