Can you make this no. to math the other no. by picking from the list ?

[sleek12]

match i mean , is it possible, i can settle for an approximation.
[TABLE="class: outer_border, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]set(use no.s from here, do not duplicate or use any no. twice,use these set only)[/TD]
[TD]opening balance[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-20362[/TD]
[TD]3697770.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]74429
74429
5260
40500
17400
9500
38600
37500
125640
61800
100000
50000
60000
170174
4400
550
327139
25850
22120
17400
13210
4000
181125
175349
179205
111260[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]to arrive at these total:-
[/TD]
[TD]3906762.00

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you & good luck. provide a macro or formula solution.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

what have YOU tried, this looks like homework

 

[sleek12]

Re: Can you make this no. to match the other no. by picking from the list ?

yes, i made attempts with trial and error method, but i suspect there should be a a more refined method to sort this issue out, trial and error is so crude in these time and age.

 

[AliGW]

Re: Can you make this no. to match the other no. by picking from the list ?

Yes, but WHAT did you try and how close was it to what you want? Please provide the formulae that you tried. Don't expect others to pick it up and do it from scratch for you.

 

[sleek12]

Re: Can you make this no. to match the other no. by picking from the list ?

No, i picked no's at random from the set, there is no particular formula i used , only copy , paste and delete. Crude method, unfortunately.

 

[mole999]

Re: Can you make this no. to match the other no. by picking from the list ?

and how was it suggested that you solve the query posed ? were you told to decide if a formula or vba was suitable, what Goal Seeking have you been learning

 

[sleek12]

The best solution i got was -20362,5260,4400,550,17400,38600,37500,125640 with a difference of 4 from final total.
Trial and error, maybe a GOAL-SEEK modified method can help to narrow the difference.

 

[AliGW]

So did you just guess? Or did you use some formula? You are not convincing me that you have tried anything beyond guesswork so far - sorry.

 

[sleek12]

I have no idea, that is why i ask if a macro or formula can be used. But see above response based on trial and error method. Yes, only guesswork. What else is there ??

 

[mole999]

This generally a forum of self help, everybody can have a say, it doesn't just take peoples problems in and provide bespoke answers (can do if you want to pay the specialists), hence asking what course you are taking. Suppose you were given a brilliant answer, well above the level you are learning at and tomorrow couldn't butter a slice of bread, you have learned nothing.

So what is it you have been learning so far?