Jagbuzz
New Member
Hi guys,
This is my first post here. I'm a big fan of chandoo and have learnt a lot over the years from this site, mostly randomly based on the need.
I have tasks that come everyday that are a direct result of employee actions or other reasons and have to be distributed equally within the team
Requirement
1. Count the number of people who are available and make an active list
2. Count the number of tasks
3. Assign the number of tasks equally
4. Assign the extra tasks randomly within the active people
Criteria
> Tasks need to be assigned only to the Active Employees
> A person cannot do his own task - exception is "Other" which can be done by anyone
> same person should not get the extra task daily (If any)
> One person cannot do the tasks of only one other person (The tasks need to be Random and Distributed)
Work Done So Far (Attached Excel)
* I was able to achieve assigning random tasks to people without assigning their own tasks through if, index formulae and named ranges
Need help with the rest of the process where i'm assigning only to active people randomly and evenly
P.s: I have posted the same question previously here and this is an upgraded version of the same
This is my first post here. I'm a big fan of chandoo and have learnt a lot over the years from this site, mostly randomly based on the need.
I have tasks that come everyday that are a direct result of employee actions or other reasons and have to be distributed equally within the team
Requirement
1. Count the number of people who are available and make an active list
2. Count the number of tasks
3. Assign the number of tasks equally
4. Assign the extra tasks randomly within the active people
Criteria
> Tasks need to be assigned only to the Active Employees
> A person cannot do his own task - exception is "Other" which can be done by anyone
> same person should not get the extra task daily (If any)
> One person cannot do the tasks of only one other person (The tasks need to be Random and Distributed)
Work Done So Far (Attached Excel)
* I was able to achieve assigning random tasks to people without assigning their own tasks through if, index formulae and named ranges
Need help with the rest of the process where i'm assigning only to active people randomly and evenly
P.s: I have posted the same question previously here and this is an upgraded version of the same