Forum Discussion
Peter1550
Jun 19, 2019Copper Contributor
Listing possible combinations
Hello Experts, What would be the formula for Excel to list all possible combinations of 5 from the set of 6? I have attached an example of the result I am looking to achieve. Thanks in advan...
JKPieterse
Jun 21, 2019Silver Contributor
I see you haven't received any responses so far. I tried looking at your sample but had a hard time figuring out what you need from the example. Perhaps you'll have more chance on a solution if you try to give us an example (using a smaller set of numbers) of the expected end result where all possible combinations are shown.
Peter1550
Jun 21, 2019Copper Contributor
Hi Jan,
I have attached another image, as you can see there is a pool of 7 numbers in separate columns. using COMBIN formula will say there are 21 possible combinations of 5 numbers from the pool of 7.
I am looking for a formula that will list those combinations.
Thanks.
Regards,
Peter