Not sure what type of formula is needed

[shternm]

I am looking for a formula that's going to look at column where there
are multiple text entries and return a list of all distict entries.

For example,
Column A
apple
apple
orange
grape
grape
grape

Column B will return
apple
orange
grape

Thanks a lot.

 

[Bernie Deitrick]

See "Extracting Unique Entries" at

http://www.cpearson.com/excel/duplicat.htm

HTH,
Bernie
MS Excel MVP

 

[Frank Kabel]

Hi
not a formula approach but you may use
'Date - Filter - Advanced Filter' and check 'Unique
records'