How to create a complete list of combinations from 5 options
The numbers can repeat which is where the list expands significantly. So I
can have 112 or 122 etc. Thats why I was looking for an automated solution.
"Gary''s Student" wrote:
If you are pick 3 of 5 (no repeats):
1, 2, 3
1, 2, 4
1, 2, 5
1, 3, 4
1, 3, 5
1, 4, 5
2, 3, 4
2, 3, 5
2, 4, 5
--
Gary''s Student - gsnu200791
"Nevermore" wrote:
I have a list of 5 possible options that I need to assemble into combinations
of 3 (order does not matter). I want to make sure the list is complete and
I'd rather not do it by hand. Can excel (or access) help me with this and how?
The order of the variables doesn't matter so 121 is the same to me as 112 or
211.
|