View Single Post
  #6   Report Post  
Old May 23rd 05, 10:32 PM
Gord Dibben
Posts: n/a


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?