Find Specific number from list of huge data

[earthworm]

I want to find a specific number that adds up to , From the list of huge combination.


The list of data can be 25000 and more and i want a small amount from the list of 25000 . it can be of any combination . I tried excel solver addon but its restricted to 100 variables . Please suggest a way
I know any solution will take lot of time but i am willing to dedicate my system for 1 hours and 2 hours etc.


Example
500
600
450
652.36
89.45

I need to identify 1152.36 from the above list . but the list is huge . >25000

 

[earthworm]

Try inserting the following into each cell:

a1:Data
a2:500
a3:600
a4:450
a5:652.36
a6:89.45

Then in column b insert:
b1:Multiplier
b2:=a2*b2
b3:=a3*b3
b4:=a4*b4
b5:=a5*b5
b6:=a6*b6

Then in column F please put the following

f2:=1152.36
f3:=sum(C:C)
f4:=sum(f2-f3)

Once you have done this, please go to solver and do the following:

1) Set objective as:
$F$4

Value off as 0


By Changing Variable Cells:
$b$2:$b$201

Subject to the Constraints:
$b$2:$b$201<=1
$b$2:$b$201=Integer
$b$2:$b$201>=0

Uncheck "Make Unconstrained....."


Then for solving method
Simplex LP

Then click "Solve"

The numbers that add up to your number of 1152.36 will have numbers change to 1 next to them. The other numbers will show 0 next to them.

This should work

Thanks.for the tip. But my data is more then 100 . This solver is restricted to length of 100 only . My data is beyond 100