Combinations

[Rafael Alvares Tubero]

Hi!


I would like to know how you guys can code all possible combinations of a... lets say... group of people.

Let me give you an example. Lets say that we have 3 people: A, B and C. Right!?

All possible combinatios is in the table below:

1	None	None	None
2	A	None	None
3	None	B	None
4	None	None	C
5	A	B	None
6	A	None	C
7	None	B	C
8	A	B	C

<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>

how can I make a code to build the table above? And for 10 people instead of 3? And for a group of n people?

Regards,

Rafael

 

[pgc01]

Hi

I posted solutions for several options with combinations.
If I understand correctly you want the power set of a set, that will be post #2 in this thread:

http://www.mrexcel.com/forum/excel-...c-applications-combinations-permutations.html

 

[Rafael Alvares Tubero]

Thank you very much!