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

Hi!

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

Biff

"Glowinafuse" wrote in message
...

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 FilterAdvanced 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
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