Hello,

I need the help of someone for a Excel formula

Sorry in advance if this is basic thing, but i am not so good with IT.

I have a company where I have 4 sales persons, I would like to allocate the same amount of client to each of them according to the territory the salespersons covers.

Let me show you:

North : 38 clients
South : 23 clients
Est : 14 clients
West : 18 clients

so I want to fairly select for each of them the same amount of clients they will have to cover, they do not need to cover all clients.
I calculated the average number, which is 23...but it does not make sense for the guys that only have 14 or 18 accounts in their territory.

Is there a formula, way to calculate the best number of client I should allocate to the salespersons ?

Thank you very much