Unique Text Values and Counts

[lgsmith0601]

Can someone help me build a list with unique text values as well as counts? I would love for them to update as i update my spreadsheet. I think the INDEX MATCH formula and CountIF function would suffice but I am not sure how to set it up. I am jsut looking to categorize unique business industries and count each unique value.

 

[AlanY]

would be easier if you post a small sample data and desired result here