Listing Unique Items

N

Neil Perry

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.
 
Top