sort a list/remove additional entries

[Glowinafuse]

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

Thanks,

Glowinafus

 

[Biff]

Hi!

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

Biff

 

[Ola]

To Count Unique items, see this link:
http://www.excelforum.com/showthread.php?goto=newpost&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]

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

 

[CLR]

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

 

[Gord Dibben]

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