He needs a quantum computer.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Harlan Grove" wrote:

Craig Wargel <Craig wrote...
....
My idea is to take a range of cells and then in the background run
a summation for every combination of cells within that range. . . .

You're unfamiliar with the math. The number of nontrivial combinations
of N numbers is 2^N-1. Even if you had a computer capable of
performing 10^10 calculations per second, it'd take several times the
age of the universe (according to cosmologists rather than Christian
fundamentalists) to calculate the sums of all combinations of even 100
numbers.

. . . The second part of the formula would be a determined number,
the out desired output of the formula would be any combinations of
the range that could be used to derive the determined number.
....

Read the entire linked thread.

http://groups.google.com/group/micro...e1064b7a215a0c

Does anyone know either how to write a formula that can do this or
who one can contact at Microsoft to request such a formula? As I
said earlier, this would be a great help to many in the accounting
and bookkeeping field when trying to reconcile an account.

Read the linked thread above. What you want has been requested MANY
times in the past, and ad hoc approaches are all that are on offer.
Macros are much more practical than functions. The lack of such a
feature is due to the gross impracticality of calculating the sums of
all combinations of even modest cardinality sets of numbers.