Hi Guys,
I'm trying to solve an assignment issue and did some decent research but couldn't find an answer anywhere. Here is what I'm trying to achieve
We have tasks that come up for actions taken by team members. The tasks need to be assigned within the team equally and randomly (one or two people can get more tasks each day as everything cant be equally distributed)
Team
John
Nate
Arnold
Amanda
Requirements
> Anyone in the team cannot be assigned his own tasks
> All the tasks need to be distributed equally and randomly (All tasks of John cant be done by Nate )
> If anyone is on leave that person needs to be excluded
> Ability to include new people to the team or exclude people
I have achieved the randomizing part using if,Index and named ranges. Would really appreciate if anyone could help me with this (Preferably a Macro)
Excel File: https://drive.google.com/file/d/0BwL...ew?usp=sharing (Couldn't upload it here due to some issue)
Bookmarks