re-visit old question

[Zab]

i hope i can explain this better than i did before. after reading my old post
i can see i was not clear at all. what i am trying to do is take this group
of numbers below and make groups not exceeding 168.
main group
23.5
23.5
30.883
30.883
30.883
30.883
37.383
37.383
43.411
43.411
47
48
49.876
50.646
50.883
50.883
50.883
50.883
50.883
50.883
50.883
50.883
55.383
55.383
59.5
90

below is an example of what i want using the numbers above.
groups of 168 or less total
50.883 + 50.883 + 50.883 = 152.649
50.883 + 50.883 + 50.883 = 152.649
48 + 43.411 + 30.883 + 30.883 = 153.177
55.383 + 50.883 + 50.883 = 157.149
50.646 + 47 + 43.411 + 23.5 = 164.557
59.5 + 55.383 + 49.876 = 164.759
90 + 37.383 + 37.383 = 164.766
30.883 + 30.883 + 23.5 = 85.266

 

[cht13er]

i hope i can explain this better than i did before. after reading my old post
i can see i was not clear at all. what i am trying to do is take this group
of numbers below and make groups not exceeding 168.
main group
23.5
23.5
30.883
30.883
30.883
30.883
37.383
37.383
43.411
43.411
47
48
49.876
50.646
50.883
50.883
50.883
50.883
50.883
50.883
50.883
50.883
55.383
55.383
59.5
90

below is an example of what i want using the numbers above.
 groups of 168 or less            total
50.883 + 50.883 + 50.883 = 152.649
50.883 + 50.883 + 50.883 = 152.649
48 + 43.411 + 30.883  + 30.883 = 153.177
55.383 + 50.883 + 50.883 = 157.149
50.646 + 47 + 43.411 + 23.5 = 164.557
59.5 + 55.383 + 49.876 = 164.759
90 + 37.383 + 37.383 = 164.766
30.883 + 30.883 + 23.5 = 85.266

Any one number: 26 results
Any combination of any two numbers: 26*25 = 650 results
Many combinations of three numbers: approx. 6,000 results or so

Are you sure you want a list 7k records long?

HTH

Chris

 

[Zab]

i'm sorry for not stating that i need only 1 result, the best result with
the fewest groups of 168 or less.

 

[Jeff Johnson]

i hope i can explain this better than i did before. after reading my old
post
i can see i was not clear at all. what i am trying to do is take this
group
of numbers below and make groups not exceeding 168.

You mean where the SUM of the numbers is less than 168? Because "groups not
exceeding 168" means "not exceeding 168 MEMBERS" to me....

 

[Zab]

yes their sum needs to be less than 168 just as i have shown in the example
above.