I have 45 input cash amounts, I need to find out if any combination of these sums to a balance
It could be just two input numbers, or it could be 35 input numbers
Example:
My input numbers are...
-1,860
1,860
48
1,300
90
50,000
-23,624
24,779
-24,779
-3,722
-3,338
-880
-152
1,561
2,404
3,338
3,722
4,957
-305,718
-41,307
-41,307
-30,980
-10,326
-6,196
-2,915
-2,571
-2,065
-87
-52
-17
17
52
87
2,065
2,571
6,196
10,326
30,980
41,307
41,307
100,503
110,168
305,718
-144
144
I need to find out if some of these can be summed to give a Balance of -209,000
I have many hundreds of these to check, with variable numbers of inputs
I can't see how to write a macro do check these
Any ideas?
Thanks in advance for any suggestions
Bookmarks