MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combinations for match of predefined sum

Posted by Jim B. on July 18, 2001 3:28 PM

I am trying to figure out a formula or macro or function in Excel to calculate the permutations (possible combinations) of a set of numbers and compare the result with a predefined number. Does anyone know how to do this or where I need to go to find more information?

Posted by Mark W. on July 18, 2001 3:38 PM

Sounds alot like this...

Is this a homework assignment?