Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007-digit separator ',' for numbers/currency exceeding 999, | Excel Discussion (Misc queries) | |||
group (add) numbers without exceeding 168" the best possible way. | Excel Discussion (Misc queries) | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |