Hi All,

I have list of customers and number of purchase orders they have placed. I am trying to see how many purchase orders my A customers (ABC Auto) have placed. I would like to do this for each letter, so all B, C, D, E.. customers. the reason being I need to assign customer service reps and I would like to base that off the alphabet so all customers that start with A would be assigned to customer service rep X. All customers that start with B to CSR Y and so on. But I want to make it balanced.

Data I have

Column A: Customer Name - 477 rows
Column B: Number of purchases (100 ea. for example)

Thanks!