Combination of numbers from that set will sum to the total

QuestionEdit

it is possible for VBA/formula do the calculation ? if can, how?

Assume Given a set of random numbers and a total,and VBA will calculate what combination of numbers from that set will sum to the total

e.g) A_no + B_no + c_no + d_no = total

AnswerEdit

VBA and formula both can calculate numbers.

In formula, you can see the calculation. If you have A_no in cell a1 B_no cell a2 and c_no in a3 and d_no in cell a4, then a formula like these in a5 will add all them up:

=a1+a2+a3+a4

or

=sum(a1:a4)

In VBA, all you do is declare variables, assign values using the cell positions and add the formula between lines of code to do the sum.

Mark

QuestionEdit

it is possible for VBA/formula do the calculation ?

Assume Given a set of random numbers and a total,and VBA will calculate what combination of numbers from that set will sum to the total

e.g) A_no + B_no + c_no + d_no = total

AnswerEdit

Kenny

I am guessing that VBA can solve the problem for you, but I am not a VBA expert. I suggest you reask the question of another allexperts person, Check the resumes for someone who is a VBA expert, I'm sure you can get a good answer. Sorry I couldn't be of more help.