Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to....?
is there a way to search a range of numbers that equal a predetermined
amount? say for ex., I have a number in one cell and a set of other numbers. Is there a way to search the set of numbers to see if there is a combination of them that add to the singl number? -- Gator |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is there a way to....?
see:
http://groups.google.com/group/micro...529de2aaf 685 but generating a table of all the possible combinations and forming the sum for each combination, the correct combination can be found. -- Gary's Student gsnu200701 "Gator" wrote: is there a way to search a range of numbers that equal a predetermined amount? say for ex., I have a number in one cell and a set of other numbers. Is there a way to search the set of numbers to see if there is a combination of them that add to the singl number? -- Gator |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|