W
Wade
I have a column of 25 values, which when summed, equal
6,262. Each value is represented by a number (i.e. 1 to
25). My goal is to split this data into two approx. equal
groups. The problem is that I need to know which
combination of values, when summed, is closest to half of
the total quantity (i.e. 3,131), and identify those values
by their corresponding number. By default, the second
group will be determined by the result of this
calculation. Can anyone help?
(1) 300
(2) 267
(3) 295
(4) 189
(5) 246
(6) 234
(7) 182
(8) 165
(9) 199
(10) 244
(11) 291
(12) 330
(13) 175
(14) 225
(15) 259
(16) 312
(17) 301
(18) 239
(19) 171
(20) 305
(21) 291
(22) 218
(23) 288
(24) 249
(25) 287
6,262. Each value is represented by a number (i.e. 1 to
25). My goal is to split this data into two approx. equal
groups. The problem is that I need to know which
combination of values, when summed, is closest to half of
the total quantity (i.e. 3,131), and identify those values
by their corresponding number. By default, the second
group will be determined by the result of this
calculation. Can anyone help?
(1) 300
(2) 267
(3) 295
(4) 189
(5) 246
(6) 234
(7) 182
(8) 165
(9) 199
(10) 244
(11) 291
(12) 330
(13) 175
(14) 225
(15) 259
(16) 312
(17) 301
(18) 239
(19) 171
(20) 305
(21) 291
(22) 218
(23) 288
(24) 249
(25) 287