You can use FilterAdvanced Filter to obtain a list of uniques in the column.
See Debra Dalgleish's site for info with pictures.
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
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?