Assign territories to Agents based on Zipcode lead history

A

archien

The data is a column of zipcodes, a column of timezones for eac
zipcode, along with a column of this past years sales leads, showing
count of the number of leads from each zipcode.
I want to assign territories to 10 sales agents based on an equa
division of the number of leads in each time zone; that is, based o
last years leads each agent would be assigned zipcodes in each tim
zone so that all agents would end up with the same number of leads i
each time zone
 
G

Guest

How many rows of data are we talking about? It might be easier just to sort
by time zone, at the bottom of each, sum up the number of leads, divide by
10, that's the number each guy gets in that zone, and go down the list until
you come up with that number, past them into another sheet, etc...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number lists based on one column 2
Query from unrelated tables help please 4
Assigning people to places based on rank and preference 7
Using formula based on text in a different cell 1
Assign a particular colour to rows based on their current status 2
Automatically assign Ranking based on Time taken 3
Assign Alpha Code to Child Record 2
How to have Excel Fill In Data in Column based on another columns 3

Top