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...

http://bbs.elementkjournals.com/bbs/showthreaded.pl?Cat=&Board=excel&Number=59235&page=0&view=collapsed&sb=5&o=0&part=

Is this a homework assignment?