Try this Tom Ogilvy classic for a way using Solver:

As a side note, Solver is limited to 200 changing cells.
I may be wrong, but it appears the op is looking among 5000 numbers.
It may require a mixture of approaches.
= = = = = =
HTH :)
Dana DeLouis

On 5/21/10 3:11 AM, Max wrote:
Try this Tom Ogilvy classic for a way using Solver:
http://tinyurl.com/5kx9bw
Link above still works, I just tested
-- Max Singapore --- "reza" wrote:
HI EXPERTS,

i hope you and excel can do this.
i have a master data with so many rows.
i.e A B C D
No Name City Values
1 - - 100
2 - - 3081
-
5000 - - 6

now my bos ask me to find values with total sum i.e 258,000 from data above.

can excel do this, or should create program using vb?
can anybody help me?

hope you understand with what i want to achieve.

thanks

regards,
reza