as seen, there are 3 a, 4 b, 7 c, 11 d, 6 f, and other id groups. here I want to divide the IDs into groups. it can be divided up to 30, but ids that are a group within themselves should not be divided. So as seen here, the first group can consist of 25 ids. If we were to divide by 30, then one of the F ids would overflow into the next group, but I don’t want that to happen. In the same way, the next group is 29. because the k id after pp is 6 and since the previous group cannot be 35 and a group cannot be more than 30, the k id is included in the next group. The next group is 20. Because we cannot include v, that is, we cannot divide it. The next group is 19. Since we cannot divide v and we cannot divide the next x, this group consists only of v. In short, we can divide up to 30 but we cannot separate the groups from themselves. Likewise, grouping ids should be taken from grouping numbers. Ex. Grup 20, Grup 29 .. How can I do this func, vba ? somehow I could not succeed. Can you help ? thank you in advance. (In both pictures, the grouping on the left is wrong and the grouping on the right is rightenter image description here.)enter image description here

frankly, I tried chatgpt and I was able to get the result on the left. more precisely, it was the healthiest result. i should also mention that my excel knowledge is not good. but I am trying. thanks.