PDA

View Full Version : Find numbers whose sum is a number given



brhum
09-30-2018, 08:16 AM
Find numbers(A4:A121) whose sum is a number given(A2)

macropod
10-01-2018, 04:44 PM
See, for example: http://www.msofficeforums.com/excel-programming/24474-combinations-calculator-excel-macro.html#post77209. Do note that the calculation effort expands exponentially as more cells (quadruplets, quintuplets, etc.) are added to the mix.