Beetlestone
New Member
- Joined
- Jan 7, 2014
- Messages
- 2
I put this on a smaller scale of 28 rows to describe it easier.
This cannot be a macro (VBA), has to be a good old fashioned formula
I have 1 column (A) with 1254 cells, each cell contains tonnage. In column B, I am trying to create "buckets" of tonnage from column A that sum up to just below 10,000, and also distribute the same number of cells in each "bucket".
That means I cant simply add up consecutive cells (ex:B1 - B12 results in 9,841). Rather I need to efficiently distribute the tonnage so that each group (or bucket) has a similar number of cells in it.
Below column B is the result I am trying to achieve, any help on this is greatly appreciated!
<tbody>
</tbody>
This cannot be a macro (VBA), has to be a good old fashioned formula
I have 1 column (A) with 1254 cells, each cell contains tonnage. In column B, I am trying to create "buckets" of tonnage from column A that sum up to just below 10,000, and also distribute the same number of cells in each "bucket".
That means I cant simply add up consecutive cells (ex:B1 - B12 results in 9,841). Rather I need to efficiently distribute the tonnage so that each group (or bucket) has a similar number of cells in it.
Below column B is the result I am trying to achieve, any help on this is greatly appreciated!
<tbody> </tbody> |
<tbody>
</tbody>