You are not logged in.
Pages: 1
Thank you, your a genius! I will get back to you in regards to the bigger challenge once I have absorbed your answer.
Regards.
I would like help for the following problem.
4 staff that can all do different tasks, Some can perform more than one task, but not at the same time
I would like to find a formula that tells me how many different ways the staff can be organized (rostered) to complete the four different tasks
TASK1 TASK2 TASK3
***** Alice Alice
Betty Betty Betty
Carol Carol *****
Dianne ***** *****
I know the answer is 7.
The 7 combinations are
Betty, Carol and Alice
Carol, Alice and Betty
Carol Betty and Alice
Denise Alice and Betty
Denise Bett and Alice
Denise Carol and Alice
Denice Carol and Betty
I want to get and Excel spread sheet to calculate the answer 7.
My Bigger problem contains 20 names and 12 Tasks so i have to careful not to over complicate the solution.
Thank you
Pages: 1