List of Categories

Originally Posted by Izzi

I would like to know if there is a way to identify the different types of categories in a column. For example:

A B
smith xx
johnson xy
jones bb
ect xx
ect bb

The file has 800 rows. Column A has a list of names but colunm B has different categories which change on a daily baisis. There could be 10 or 15 different categories at one time but would be hard to identify all different categories over 800 rows. Is there a way I could have a list populated on a a column with the names of the different categories. This would be similiar to how Excel identifies its categories when you select its the AutoFilter.

Thanks

Try Advanced Filter, Unique Records Only, Copy to another location.

hth
---