Does anyone know how to create a formula with 5 sets of numbers that
have to equal another number? For example, if
Set 1 = (1,2,3)
Set 2 = (4,5,6)
Set 3 = (7,8,9)
Set 4 = (10,11,12)
Set 5 = (13,14,15)

I would want the formula to pick one number from each set so that the
sum of these numbers would equal 40. Is there a way to write a formula
in Excel that would create all of the possible number combinations
(using the 5 sets) that equal a given number?

Thanks in advance for your help!

Spencer



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/