Round Robin Assignment

[kshitij_dch]

Hello Team,

I am working on a sheet wherein i have 50 city name, Each City has 4-5 persons representing the city. ( Column A , has Name of Persons , column B has city name represented by person in column A)

I get leads to be assigned according to city name , lets say if City A has 5 Persons and i got 20 leads to be assigned to City A than those 20 leads to be equally distributed between 5 persons by round robin approach.

1 , 2 , 3 , 4 , 5 ......again 1 , 2 , 3 , 4 , 5 ...........at the end 5 persons end up with 4 leads each by round robin approach.

I their any way to do it , formula or a VBA Code to do it ?

 

[FormR]

I get leads to be assigned according to city name

Hi, you've told us where the list of city's and people are, but you've not told us where the leads are, what they look like or what the expected results are in relation to that.

The best way to show us this is by posting some sample data using the XL2BB addin.

 

[NdNoviceHlp]

You can take a look at this thread to see if it's useful. Dave

Round Robin

Hi, very new to this so please be gentle. Im trying to make a round robin draw for my local league. 20 players to play each other 3 times, `Ive searched the web and tried all sorts of different things to no avail, please if any help is available would much appreciate it.

www.mrexcel.com