On Apr 28, 9:56*am, Zab wrote:
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

--
Thank You in advance, Zab

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