Get a list of all items in a column?

[[email protected]]

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

[Bob Phillips]

Data>Filter>Advanced Filter, it has a Unique Records option

--

HTH

Bob Phillips

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

<[email protected]> wrote in message
news:[email protected]...
> 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
>