How to create a complete list of combinations from 5 options
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.
|