Hi- So I need to count the number of markets (ex. Flint MI Pittsburgh PA) that are in one column based on whether or not they are assigned to a specific region such as "West", South East etc;

Example: There are multiple markets listed in each region and I need to count how many markets are in each region without counting duplicate market names. Any help would be greatl

Column B: Column C:
Market Name Region