Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visit Calculation | Excel Worksheet Functions | |||
Formula help! counting one visit clients | Excel Discussion (Misc queries) | |||
Identifying the last visit | Excel Worksheet Functions | |||
Re : Excel Experts E-letter (No. 19, Re-Visit) ; POWER FORMULA TECHNIQUES | Excel Programming |