Listing Unique Items

[Guest]

If I have a list in a column, for example:

Arthur, Arthur, Arthur, Bert, Bert, Charlie, Charlie, Charlie, Charlie,
Derek, Eric, Eric

How can I summarise this list to display only one instance of each unique
item, e.g.

Arthur, Bert, Charlie, Derek, Eric

I have looked through filtering and cannot find any info. Please can anyone
offer any suggestions?

Thanks in Advance.

 

[Frank Kabel]

Hi
use 'Data - filter - Advanced Filter' and check 'Unique entries'

 

[Ron de Bruin]

Hi Neal

Data>Filter..Advanced Filter you can use
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[Guest]

Found this very useful - thanks for your help
Neil