Basically the only thing I know how to do in Excel is use basic arithmetic. I
don't know the formulas or functions at all. But if you have 60 numbers and
we call them n1, n2, n3 etc. couldn't you add n1+n2 and test the result
against the target number, then if it was wrong add n1+n2+n3 and test, etc.
until you added all 60 numbers. Then after that, start with n2, adding n2+n3,
then n2+n3+n4, etc. the last in this series being n2+n3...+n60+n1. I don't
know if this makes sense or would exhaust all the possibilities. And, in any
case, I don't know how to write the formula.
Another idea. Contine to add random combinations of the 60 numbers, testing
against the target figure each time, then let the formula run all night.
Wouldn't all combinations likely be exhausted by morning? But again, I don't
know how to write this?
"Ron Rosenfeld" wrote:
Not easily and there would be a lot of potential ambiguity.
|