Dividing rows into groups based on two parameters

[thomazzs]

Dear all,

I have the following problem: I need to divide the rows below into groups, based on two criteria.

e.g. The sum of Balls <= 10.000 & the sum of Bucket <= 5

the order of the rows cannot change.

Is there an (easy) way to let excel determine these groups?


the result in the row "group" would (for this example) be as follows:

[TABLE="width: 336"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Balls[/TD]
[TD]Bucket[/TD]
[TD]Group[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]5037[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2601[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1584[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1534[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3133[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]9002[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]15[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]14[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]20[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 336"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

I can't see from that example what Bucket has to do with it.
This formula in D2, copied down produces those results.
If this is not what you need, perhaps another example that demonstrates all the possibilities and further explanation may help.

Excel Workbook
	A	B	C	D
1	Order	Balls	Bucket	Group
2	1	5037	1	1
3	2	2601	1	1
4	3	1584	1	1
5	4	1534	1	2
6	5	3133	2	2
7	6	9002	1	3
8	7	7	1	3
9	8	15	1	3
10	9	14	1	3
11	10	20	1	3
Groups