valuechained
Board Regular
- Joined
- Oct 24, 2007
- Messages
- 63
Hi guys,
I hope you can help me with a particularly tricky problem that I encountered this morning.
I have several items that I would like to combine, lets call them characters A, B, C, D, E
Each character is situated in a different column, next to each other. Below, I would like to create a list of all possible combinations of these characters. The sequence is not important and each row should contain a unique combination of characters.
I have counted 31 combinations for the ABCDE set, namely
1 for ABCDE
5 for A, B, C, D, E each
5 for choosing 5 unique sets of four from a set of five (5!/(4!*(5-4)!)
10 for choosing 10 unique sets of three from a set of five (5!/(3!*(5-3)!)
10 for choosing 10 unique sets of two from a set of five (5!/(2!*(5-2)!)
To complicate matters, I have several other character strings where I would like a list of combinations. For example A, B, C, D, E, F, G, H 9 (a longer set).
By the way, each combination should be spread accross several columns (e.g. one colum per character, see the question marks in the table below)
Any advice would be very much appreciated. This makes my head spin since a couple of hours.
I hope you can help me with a particularly tricky problem that I encountered this morning.
I have several items that I would like to combine, lets call them characters A, B, C, D, E
Each character is situated in a different column, next to each other. Below, I would like to create a list of all possible combinations of these characters. The sequence is not important and each row should contain a unique combination of characters.
I have counted 31 combinations for the ABCDE set, namely
1 for ABCDE
5 for A, B, C, D, E each
5 for choosing 5 unique sets of four from a set of five (5!/(4!*(5-4)!)
10 for choosing 10 unique sets of three from a set of five (5!/(3!*(5-3)!)
10 for choosing 10 unique sets of two from a set of five (5!/(2!*(5-2)!)
To complicate matters, I have several other character strings where I would like a list of combinations. For example A, B, C, D, E, F, G, H 9 (a longer set).
By the way, each combination should be spread accross several columns (e.g. one colum per character, see the question marks in the table below)
Any advice would be very much appreciated. This makes my head spin since a couple of hours.
question.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
3 | Category | A | B | C | D | E | ||
4 | Permutation1 | ? | ? | ? | ? | ? | ||
5 | Permutation2 | ? | ? | ? | ? | ? | ||
6 | Permutation3 | ? | ? | ? | ? | ? | ||
7 | Permutation4 | ? | ? | ? | ? | ? | ||
8 | Permutation5 | ? | ? | ? | ? | ? | ||
9 | Permutation6 | ? | ? | ? | ? | ? | ||
10 | Permutation7 | ? | ? | ? | ? | ? | ||
11 | Permutation8 | ? | ? | ? | ? | ? | ||
12 | Permutation9 | ? | ? | ? | ? | ? | ||
13 | Permutation10 | ? | ? | ? | ? | ? | ||
14 | Permutation11 | ? | ? | ? | ? | ? | ||
15 | Permutation12 | ? | ? | ? | ? | ? | ||
16 | Permutation13 | ? | ? | ? | ? | ? | ||
17 | Permutation14 | ? | ? | ? | ? | ? | ||
18 | Permutation15 | ? | ? | ? | ? | ? | ||
19 | Permutation16 | ? | ? | ? | ? | ? | ||
20 | Permutation17 | ? | ? | ? | ? | ? | ||
21 | Permutation18 | ? | ? | ? | ? | ? | ||
22 | Permutation19 | ? | ? | ? | ? | ? | ||
23 | Permutation20 | ? | ? | ? | ? | ? | ||
24 | Permutation21 | ? | ? | ? | ? | ? | ||
25 | Permutation22 | ? | ? | ? | ? | ? | ||
26 | Permutation23 | ? | ? | ? | ? | ? | ||
27 | Permutation24 | ? | ? | ? | ? | ? | ||
28 | Permutation25 | ? | ? | ? | ? | ? | ||
29 | Permutation26 | ? | ? | ? | ? | ? | ||
30 | Permutation27 | ? | ? | ? | ? | ? | ||
31 | Permutation28 | ? | ? | ? | ? | ? | ||
32 | Permutation29 | ? | ? | ? | ? | ? | ||
Sheet1 |