Finding out how many different items are contained within a column

D

dave

Hi there,
I have a large column of text data, many of which contain repeated data. How
can i perform a filter or query that returns me a list of the data, but just
one entry for each particular piece of data.
e.g

dave
bob
alan
bob dave
dave would give => bob
kevin alan
bob kevin
alan james
dave
james
james
bob

thanks
dave
 
Top