Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
group (add) numbers without exceeding 168" the best possible way.
hello i am triing to group these numbers below, but i do not want the total
to exceed 168. i need to know how many pieces that are 168 in length it will take. i would imagine it will take some vba to conduct this and i am fine with this. 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 i have manually grouped the numbers together with their totals to the right. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: top of screen "File Name [Group]", how to remove [Grou | Excel Discussion (Misc queries) | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
I cannot get my Excel sheets to "Group". (Student version 2003) | New Users to Excel | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) |