using Excel Solver
 

From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be
value 2 and so on).

how do i get excel solver to choose for me cells that can possibly add up to
a value of 22?

using Excel Solver
 

would you expand?

how many cells?

using Excel Solver
 

Put 1 in each cell in B1:B100
In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
Solver:
Target C1; Value 22
By changing B1:B100
Constraint B1:B100 binary
Solve
There can be many answers, Solver gives one that depends on initial state
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kenneth" wrote in message
...
From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be
value 2 and so on).

how do i get excel solver to choose for me cells that can possibly add up
to
a value of 22?

using Excel Solver
 

There can be many answers, Solver gives one that depends on initial state
best wishes

Just to mention...combination theory says there are 89 Solutions to this
particular problem.

--
Dana DeLouis


"Bernard Liengme" wrote in message
...
Put 1 in each cell in B1:B100
In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
Solver:
Target C1; Value 22
By changing B1:B100
Constraint B1:B100 binary
Solve
There can be many answers, Solver gives one that depends on initial state
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kenneth" wrote in message
...
From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will
be
value 2 and so on).

how do i get excel solver to choose for me cells that can possibly add up
to
a value of 22?

using Excel Solver
 

thanks a lot! (:

"Bernard Liengme" wrote:

Put 1 in each cell in B1:B100
In C1 enter =SUMPRODUCT(A1:A100,B1:B100)
Solver:
Target C1; Value 22
By changing B1:B100
Constraint B1:B100 binary
Solve
There can be many answers, Solver gives one that depends on initial state
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Kenneth" wrote in message
...
From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be
value 2 and so on).

how do i get excel solver to choose for me cells that can possibly add up
to
a value of 22?