software

I have a list of numbers (approximately 3000) that sum to X. However, my
control figure is Y.

Is there a formula that will evaluate the list of 3000 numbers and return
those that when summed, equal the difference between X and Y?

You could do this with Solver but with 3000 number, it is unlikely that
there is a unique solution.
Do you care?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;simmerdownquot; gt; wrote in message
...
gt;I have a list of numbers (approximately 3000) that sum to X. However, my
gt; control figure is Y.
gt;
gt; Is there a formula that will evaluate the list of 3000 numbers and return
gt; those that when summed, equal the difference between X and Y?
No, I don't care. At least that would narrow down the field, then I could
take it from there.

quot;Bernard Liengmequot; wrote:

gt; You could do this with Solver but with 3000 number, it is unlikely that
gt; there is a unique solution.
gt; Do you care?
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;simmerdownquot; gt; wrote in message
gt; ...
gt; gt;I have a list of numbers (approximately 3000) that sum to X. However, my
gt; gt; control figure is Y.
gt; gt;
gt; gt; Is there a formula that will evaluate the list of 3000 numbers and return
gt; gt; those that when summed, equal the difference between X and Y?
gt;
gt;
gt;

Assuming your numbers are in A1:A3000
In B1:B3000 enter 1
C1 =SUMPRODUCT(A1:A3000, B1:B3000), C2 = Y (your target), C3 = ABS(C1-C2)

In Solver
Changing cells B1:B3000
Constraints C3=0 and B1:B3000 bin (binary - i.e. 0 or 1)
Solve

Does it work with your data?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from emailquot;simmerdownquot; gt; wrote in message
...
gt; No, I don't care. At least that would narrow down the field, then I could
gt; take it from there.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; You could do this with Solver but with 3000 number, it is unlikely that
gt;gt; there is a unique solution.
gt;gt; Do you care?
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;simmerdownquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a list of numbers (approximately 3000) that sum to X. However,
gt;gt; gt;my
gt;gt; gt; control figure is Y.
gt;gt; gt;
gt;gt; gt; Is there a formula that will evaluate the list of 3000 numbers and
gt;gt; gt; return
gt;gt; gt; those that when summed, equal the difference between X and Y?
gt;gt;
gt;gt;
gt;gt;
I really appreciate your help.

After inputting the information as described, once I hit quot;solverquot; I receive
a message that says quot;too many adjustable cellsquot;.

Any thoughts?

quot;Bernard Liengmequot; wrote:

gt; Assuming your numbers are in A1:A3000
gt; In B1:B3000 enter 1
gt; C1 =SUMPRODUCT(A1:A3000, B1:B3000), C2 = Y (your target), C3 = ABS(C1-C2)
gt;
gt; In Solver
gt; Changing cells B1:B3000
gt; Constraints C3=0 and B1:B3000 bin (binary - i.e. 0 or 1)
gt; Solve
gt;
gt; Does it work with your data?
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt;
gt; quot;simmerdownquot; gt; wrote in message
gt; ...
gt; gt; No, I don't care. At least that would narrow down the field, then I could
gt; gt; take it from there.
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; You could do this with Solver but with 3000 number, it is unlikely that
gt; gt;gt; there is a unique solution.
gt; gt;gt; Do you care?
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt; quot;simmerdownquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have a list of numbers (approximately 3000) that sum to X. However,
gt; gt;gt; gt;my
gt; gt;gt; gt; control figure is Y.
gt; gt;gt; gt;
gt; gt;gt; gt; Is there a formula that will evaluate the list of 3000 numbers and
gt; gt;gt; gt; return
gt; gt;gt; gt; those that when summed, equal the difference between X and Y?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Play with a smaller set of data and see if that works.
If so we can try to work out something
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;simmerdownquot; gt; wrote in message
...
gt;I really appreciate your help.
gt;
gt; After inputting the information as described, once I hit quot;solverquot; I
gt; receive
gt; a message that says quot;too many adjustable cellsquot;.
gt;
gt; Any thoughts?
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Assuming your numbers are in A1:A3000
gt;gt; In B1:B3000 enter 1
gt;gt; C1 =SUMPRODUCT(A1:A3000, B1:B3000), C2 = Y (your target), C3 = ABS(C1-C2)
gt;gt;
gt;gt; In Solver
gt;gt; Changing cells B1:B3000
gt;gt; Constraints C3=0 and B1:B3000 bin (binary - i.e. 0 or 1)
gt;gt; Solve
gt;gt;
gt;gt; Does it work with your data?
gt;gt;
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt;
gt;gt; quot;simmerdownquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; No, I don't care. At least that would narrow down the field, then I
gt;gt; gt; could
gt;gt; gt; take it from there.
gt;gt; gt;
gt;gt; gt; quot;Bernard Liengmequot; wrote:
gt;gt; gt;
gt;gt; gt;gt; You could do this with Solver but with 3000 number, it is unlikely
gt;gt; gt;gt; that
gt;gt; gt;gt; there is a unique solution.
gt;gt; gt;gt; Do you care?
gt;gt; gt;gt; --
gt;gt; gt;gt; Bernard V Liengme
gt;gt; gt;gt; www.stfx.ca/people/bliengme
gt;gt; gt;gt; remove caps from email
gt;gt; gt;gt;
gt;gt; gt;gt; quot;simmerdownquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have a list of numbers (approximately 3000) that sum to X.
gt;gt; gt;gt; gt;However,
gt;gt; gt;gt; gt;my
gt;gt; gt;gt; gt; control figure is Y.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Is there a formula that will evaluate the list of 3000 numbers and
gt;gt; gt;gt; gt; return
gt;gt; gt;gt; gt; those that when summed, equal the difference between X and Y?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
I narrowed the data down to about 25 figures. Again, I'm trying to
determine, of these figures, which of these when summed adds to X.

I used the solver listed below on the 25 figures, however I'm not sure I
understand the results.

Is there a possibility I could email you a sample file?

quot;Bernard Liengmequot; wrote:

gt; Play with a smaller set of data and see if that works.
gt; If so we can try to work out something
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;simmerdownquot; gt; wrote in message
gt; ...
gt; gt;I really appreciate your help.
gt; gt;
gt; gt; After inputting the information as described, once I hit quot;solverquot; I
gt; gt; receive
gt; gt; a message that says quot;too many adjustable cellsquot;.
gt; gt;
gt; gt; Any thoughts?
gt; gt;
gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;
gt; gt;gt; Assuming your numbers are in A1:A3000
gt; gt;gt; In B1:B3000 enter 1
gt; gt;gt; C1 =SUMPRODUCT(A1:A3000, B1:B3000), C2 = Y (your target), C3 = ABS(C1-C2)
gt; gt;gt;
gt; gt;gt; In Solver
gt; gt;gt; Changing cells B1:B3000
gt; gt;gt; Constraints C3=0 and B1:B3000 bin (binary - i.e. 0 or 1)
gt; gt;gt; Solve
gt; gt;gt;
gt; gt;gt; Does it work with your data?
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Bernard V Liengme
gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; remove caps from email
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;simmerdownquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; No, I don't care. At least that would narrow down the field, then I
gt; gt;gt; gt; could
gt; gt;gt; gt; take it from there.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Bernard Liengmequot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt;gt; You could do this with Solver but with 3000 number, it is unlikely
gt; gt;gt; gt;gt; that
gt; gt;gt; gt;gt; there is a unique solution.
gt; gt;gt; gt;gt; Do you care?
gt; gt;gt; gt;gt; --
gt; gt;gt; gt;gt; Bernard V Liengme
gt; gt;gt; gt;gt; www.stfx.ca/people/bliengme
gt; gt;gt; gt;gt; remove caps from email
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;simmerdownquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;I have a list of numbers (approximately 3000) that sum to X.
gt; gt;gt; gt;gt; gt;However,
gt; gt;gt; gt;gt; gt;my
gt; gt;gt; gt;gt; gt; control figure is Y.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Is there a formula that will evaluate the list of 3000 numbers and
gt; gt;gt; gt;gt; gt; return
gt; gt;gt; gt;gt; gt; those that when summed, equal the difference between X and Y?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;