Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |