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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.