sort a list/remove additional entries

Okay, I have a coumn with like 10,000 lines. They have maybe 70
different names in them. I need to find out what all names od
categories are in there. Without having to search line by line. Is
there a way to do this?

Thanks,

Glowinafuse


--
Glowinafuse

Hi!

Use an advanced filter to copy the unique values to a different location.

Biff

"Glowinafuse" <Glowinafuse.1phz8y@news.excelbanter.com> wrote in message
news:Glowinafuse.1phz8y@news.excelbanter.com...
>
> Okay, I have a coumn with like 10,000 lines. They have maybe 70
> different names in them. I need to find out what all names od
> categories are in there. Without having to search line by line. Is
> there a way to do this?
>
> Thanks,
>
> Glowinafuse
>
>
> --
> Glowinafuse

To Count Unique items, see this link:
http://www.excelforum.com/showthread...wpost&t=373153

To Create a list with only the Unique items, see this link:
http://www.excelforum.com/showthread.php?t=372854

Hope it helps
Ola Sandström

check out <data><filter><advanced filter> unique data

"Glowinafuse" wrote:

>
> Okay, I have a coumn with like 10,000 lines. They have maybe 70
> different names in them. I need to find out what all names od
> categories are in there. Without having to search line by line. Is
> there a way to do this?
>
> Thanks,
>
> Glowinafuse
>
>
> --
> Glowinafuse
>

Click on an item in the column, then Data > Filter > AutoFilter.......then
click on the arrow at the top of the column......the drop-down box will have
one entry for each unique item on the list.........to get out of the
AutoFilter mode, just do Data > Filter > AutoFilter again, it's a toggle......


Vaya con Dios,
Chuck, CABGx3



"Glowinafuse" wrote:

>
> Okay, I have a coumn with like 10,000 lines. They have maybe 70
> different names in them. I need to find out what all names od
> categories are in there. Without having to search line by line. Is
> there a way to do this?
>
> Thanks,
>
> Glowinafuse
>
>
> --
> Glowinafuse
>

Glow

You can use Filter>Advanced Filter to obtain a list of uniques in the column.

See Debra Dalgleish's site for info with pictures.

http://www.contextures.on.ca/xladvfilter01.html

Note: you can copy the list to another sheet or range.


Gord Dibben Excel MVP

On Mon, 23 May 2005 19:10:40 +0100, Glowinafuse
<Glowinafuse.1phz8y@news.excelbanter.com> wrote:

>
>Okay, I have a coumn with like 10,000 lines. They have maybe 70
>different names in them. I need to find out what all names od
>categories are in there. Without having to search line by line. Is
>there a way to do this?
>
>Thanks,
>
>Glowinafuse