Get a list of all items in a column?

  • Thread starter Thread starter dmlippert
  • Start date Start date
D

dmlippert

I have a column with hundreds of entries in it, what I want to do is,
at the bottom of said column, generate a list of each individual entry.
So, if Tokyo shows up 30 times, I want it to show up only once at the
bottom, is there an easy way of do this?

So, from
Cat
Dog
Bear
Bear
Cat
Cat
Dog
Bear
Bear
Cat
Donkey
Dog
Elephant
Cat
Turkey
Donkey
Dog
Donkey
Dog
Elephant
Cat
Turkey
Donkey
Dog

to

Cat
Dog
Bear
Donkey
Elephant
Turkey
 
Data>Filter>Advanced Filter, it has a Unique Records option

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

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

Can i use If to check if a cell is equal to any value in a particular range 1
Most Frequently used Text value in a column 9
can I sort text data into bins? 2
Running queries 1
Display Unique Values 4
Search a Table, find, and copy all data from the row 2
Counting Values in a list 2
Count the unique entries in a column of data 3

Back
Top