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