Finding out how many different items are contained within a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
actually, its ok, i've sussed it out, so you can ignore this post
cheers
dave
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find matching records in two tables using mulitiple criteria 1
searching multiple tables 2
Finding/Copying Top 10 Items From A List 2
Converting a table containing Records of irregualar number of fields to a normal Table 5
Search for Employee Names 2
sumif column contains text 7
It's a filter but not a filter 2
Date Filter 5

Back
Top