Prev: Format Rows
Next: Data to Date conversion with multiple formats
From: tomm on 26 Jan 2010 22:59
Hi,
I wish to find only the number of permutations of the following example. There are 4 employees who are able to perform different tasks. If they are working one task, they cannot work on another.

Task#1 Task#2 Task#3
****** Alice Alice
Betty Betty Betty
Carol Carol ******
Denise ****** ******

Eg: Alice can only perform Task#2 or Task#3
Eg; Betty can perform either Task#1 or Task#2 or Task#3
Eg: Carol can perform Task#1 or Task#2
Eg: Denise can only perform Task#1

There are 7 combinations of tasks that can be achieved.

Betty Carol Alice
Carol Alice Betty
Carol Betty Alice
Denise Alice Betty
Denise Betty Alice
Denise Carol Alice
Denise Carol Betty

All I need to know is the solution "7". I do not need to know the different combinations. I wish to perform this calculation on an EXCEL spreadsheet without using macros and VBA.

On another board, I was kindly given the formula
(B+C+D)*(A+B+C)*(A+B)
This gives me a solution of sorts but I cannot seem to sort the wheat from the charf.

Once I can find a solution, I wish to expand it to a larger set of tasks and people.

I have spent ages on this and are really looking for help.
Regards



Submitted via EggHeadCafe - Software Developer Portal of Choice
Note to Active Forum Posters
http://www.eggheadcafe.com/tutorials/aspnet/bffd1eb4-da2f-426f-a6ba-4d5da9453164/note-to-active-forum-post.aspx
From: Herbert Seidenberg on 27 Jan 2010 21:18
Excel 2007 Table
Combinations.
No macros.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_27_10.xlsx


 | 
Pages: 1
Prev: Format Rows
Next: Data to Date conversion with multiple formats