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 |
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 |
All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com