ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sort a list/remove additional entries (https://www.excelbanter.com/excel-worksheet-functions/27287-sort-list-remove-additional-entries.html)

Glowinafuse May 23rd 05 07:10 PM

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

Biff May 23rd 05 08:03 PM

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




Ola May 23rd 05 08:24 PM

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

bj May 23rd 05 08:26 PM

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


CLR May 23rd 05 08:26 PM

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


Gord Dibben May 23rd 05 10:32 PM

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 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com