Macro - Grouping rows with constraints

[Jaime1182]

Hi all

I have to group rows with some limitations:
a. Each group cannot exceed 4 rows (but can be less)
b. A group may "spillover" to the next, except if the next group can fit itself perfectly within a new group itself - :'(

The logic is a little strange.

I tried to count the number of instances then divide by the 4, but then got all tangled up because I got a number which defined how many groups was required, but not which group the rows were in!

Team Leads.jpg

Have no clue how to approach this.

[karedog]

Maybe :

Please Login or Register  to view this content.

[Jaime1182]

Hi! Thank you so much for this. I'll try it out and report back.

Just wanted to ask something:

Please Login or Register  to view this content.

We define "1 To 3" because it's a group of 4 right? If this changes next time to a different number like 5, will it then be "1 To 4"?

Thanks again!

[karedog]

You are welcome and thanks for the reps given.

No, 1 to 3 here, is because the macro works in 3 phase :
Phase 1 : Any rows that can be grouped, because they have same data, are fall in this phase (in above example, they are rows 2:5, 10:13, 15:18)
Phase 2 : Any rows that can be grouped, not have same data (remaining of phase 1) but the members is enough to form a new group , are fall in this phase (in above example, they are rows 6:9)
Phase 3 : Any other rows remaining of phase 1 and 2, fall in this phase

I have modified the code on post #2, by defining :
Const nGroup As Long = 4
so the macro can be adjusted to any number you want, just try to change this value to see the result.

[Jaime1182]

Hi there!

Thanks so much for explaining. I really appreciate it!

[karedog]

You are welcome Jaime, and don't forget to mark this thread as solved.

Regards