kshitij_dch
Active Member
- Joined
- Apr 1, 2012
- Messages
- 362
- Office Version
- 365
- 2016
- 2007
- Platform
- Windows
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 ?
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 ?