finding one value by combining many
 

I have spent hours and hours trying to do this question and I am looking for
someone to tell me if it can or can't. Here is what I am trying to do:

I am off in some calculations by a value, lets use 100. I have a list of
about 250 numbers and I am trying to find a formula or macro that would let
me search the list of 250 items and have it produce all number calculations
that would equal 100.

For example, cell1 is 9, cell2 is 45, cell3 is 8 and cell4 is35. Together
these 4 values equal 100.

Cell 76 is 50, cell4 is 35, and cell9 is 15. This also equals 100 so it
would produce another line of output. Can it produce a list of all
combinations of cells whereas each combination of 100 would produce some
output? Is this possible, perhaps an advanced filter sort of function? Any
help would be greatly appreciated.

finding one value by combining many
 

T,

You can't do it.

You can solve this sort of thing for up to about 30 to 50 or so values - For your levels, you would
need supercomputers running for longer than the age of the universe - OK, maybe not that bad, but
your PC won't handle it anytime soon.....

HTH,
Bernie
MS Excel MVP


"Trandall37" wrote in message
...
I have spent hours and hours trying to do this question and I am looking for
someone to tell me if it can or can't. Here is what I am trying to do:

I am off in some calculations by a value, lets use 100. I have a list of
about 250 numbers and I am trying to find a formula or macro that would let
me search the list of 250 items and have it produce all number calculations
that would equal 100.

For example, cell1 is 9, cell2 is 45, cell3 is 8 and cell4 is35. Together
these 4 values equal 100.

Cell 76 is 50, cell4 is 35, and cell9 is 15. This also equals 100 so it
would produce another line of output. Can it produce a list of all
combinations of cells whereas each combination of 100 would produce some
output? Is this possible, perhaps an advanced filter sort of function? Any
help would be greatly appreciated.