Hello everyone,
This thread, is the continuation of this thread
http://chandoo.org/forum/threads/combination-the-product-of-two-columns.22967/page-2,
Started about one topic, and spreading to another subject.
I guess everyone is familiar with this wonderful blog,http://excelxor.com/
The man,XOR LX,who created the wonderful post,
http://excelxor.com/2015/02/10/which-numbers-add-up-to-total-2-multiple-solutions/
A combination of 3 numbers, the sum is 20.
I want to do it in another way, not sure that's possible.
I'll give examples, with a table, but the target is to reach a solution without the use of a table, but only through a formula, no matter how long it will be.
When you have 10 numbers, and you want to find a certain amount with 3 numbers out of 10.
The easiest way, but it does not seem possible to construct it,
120 lines,=COMBIN(10,3) or =(10*9*8)/3/2/1.Each combination is unique.
The second way, less comfortable, and difficult construction,permutations Without Repetition ,=PERMUT(10,3) or 10*9*8,720 lines ,three columns,each row, there is no number is repeated.
The third way ,The least comfortable, but I think there is a complete solution using a formula,
permutations with Repetition 10^3,1000 lines,
The first step to neutralize from 1000 lines ,280 lines ,this same lines where a certain number appears more than once.720 lines remained, with whom should reach combinations,
I attach two files, the first file,permutations with Repetition ,Table with 1000 rows and three columns.
The second file,permutations Without Repetition,1000 should also be lines, but I built the table with 720 rows necessary,illustration.
The second step, to find unique combinations ,each combination numbers appear six times, I want to prevent this.6= (3*2*1),
Columns N;P,List combinations,
Amount requested Cell L8,
That total combinations Cell J11.
Regards
David
This thread, is the continuation of this thread
http://chandoo.org/forum/threads/combination-the-product-of-two-columns.22967/page-2,
Started about one topic, and spreading to another subject.
I guess everyone is familiar with this wonderful blog,http://excelxor.com/
The man,XOR LX,who created the wonderful post,
http://excelxor.com/2015/02/10/which-numbers-add-up-to-total-2-multiple-solutions/
A combination of 3 numbers, the sum is 20.
I want to do it in another way, not sure that's possible.
I'll give examples, with a table, but the target is to reach a solution without the use of a table, but only through a formula, no matter how long it will be.
When you have 10 numbers, and you want to find a certain amount with 3 numbers out of 10.
The easiest way, but it does not seem possible to construct it,
120 lines,=COMBIN(10,3) or =(10*9*8)/3/2/1.Each combination is unique.
The second way, less comfortable, and difficult construction,permutations Without Repetition ,=PERMUT(10,3) or 10*9*8,720 lines ,three columns,each row, there is no number is repeated.
The third way ,The least comfortable, but I think there is a complete solution using a formula,
permutations with Repetition 10^3,1000 lines,
The first step to neutralize from 1000 lines ,280 lines ,this same lines where a certain number appears more than once.720 lines remained, with whom should reach combinations,
I attach two files, the first file,permutations with Repetition ,Table with 1000 rows and three columns.
The second file,permutations Without Repetition,1000 should also be lines, but I built the table with 720 rows necessary,illustration.
The second step, to find unique combinations ,each combination numbers appear six times, I want to prevent this.6= (3*2*1),
Columns N;P,List combinations,
Amount requested Cell L8,
That total combinations Cell J11.
Regards
David
Last edited: