How to produce list of all the different items present in a column?

[Legacy 190046]

Need a Microsoft Excel genius here!

Say my Dogs worksheet has 3000+ rows of dogs; each column stores a different fact about the dogs; one column is labeled Breed. Of course there will be many dogs in which share the same breed, but there's a certain number of different breeds contained in the worksheet overall.

How can I produce a list of all the different breeds in this column without sorting by this column and manually scrolling through it all?


For example, if the column's first 8 values were:

• Collie
• Terrier
• Terrier
• Hound
• Terrier
• Collie
• Beagle
• Beagle

Then I'd query Excel and get this list:

Collie, Terrier, Hound, Beagle

 

[Gary McMaster]

"Advanced Filter" will probably work.

http://www.contextures.com/xladvfilter01.html

Gary

 

[Legacy 190046]

That worked! Thanks!

 

[brettdj]

For more complicated extractions (some samples below) another option ismy duplicate master addin http://www.experts-exchange.com/A_2123.html

- accross mutiple sheets
- ignoring case sensitivities/white spaces
- picking true uniques that only occur once

Cheers

Dave