|Try the technique found at the following link. It should find a set of numbers that add up to your total. Whether it find the exact 34 that you are looking for will depend on whether or not there are more than one set of set numbers that SUM to that total.|
For example, if I have these 8 numbers and want to find which ones SUM to 6, the technique shown will only find 1 set when there are techically multiple sets.
1, 2, 2, 2, 2, 1, 3, 3
In any case, it's pretty neat. Hopefully it will find the 34 numbers that you are looking for.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.