Need to find which values in a column add up to known value

[Guest]

I have a column of numbers and need to find out if any combination of them
add up to a known value that I have.

 

[Frank Kabel]

Hi
some questions
- do you only need one combination or all
- do you also have negative numbers in your range
- how many values (>40)

If you answer all these questions with yes: No way^IMHO as you probably
won't wait for several months/years for the calculation to finish )

 

[Guest]

These are my values:

114.4
575.19
394.02
401.52
494.4
736.69
487.95
640.6
390.36
487.95
160.15
480.45
640.6
448.42
422.89
800.75
401.52
384.36
882.96
585.54
495.45
468.44
441.48
390.36
553.01
602.28
501.9
441.48
396.36
528.48
455.42
528.48
520.48
396.36
878.31
475.44
594.54
401.52
441.48
420.68
396.36
407.52
455.42
407.52
407.52
407.52
528.48
635.74
487.95
627.57
407.52
407.52
535.36
478.94
434.98
432.64
650.6
495.45
462.42
444.73
975.9
410.52
455.42
391.14
391.14
441.48
169.45
407.52
509.4
453.18
402.3
485.55
389.76
396.36
502.88
582.66
649.6
768.72
390.36
384.37
461.44
398.22
494.4
896.84
451.57
478.95
95.79
1,255.69
335.03
174.75
372.13
407.75
87.38
474
414.75
574
177.75
352.5
1,799.88

This is that value that I need to determine if any combination of the above
values is equal to:

923.33

 

[Gord Dibben]

chad

Have a look at the code provided by Brian Baulsom in this thread.

http://snipurl.com/ajtw

As Frank said and Brian points out.......go out for the weekend.

Gord Dibben Excel MVP