Hope I can describe this well....

I have a spreadsheet of competitor sales that I have assigned our salesmen to. The columns are:

Company name / address / city / equipment /salerep

Many of the customers are listed multiple times as they have purchased multiple equipment.

I would like to provide a total number of customers in each sales persons territory, while leaving all of the other data intact. Is there an easy way to do this?