This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello, I am working with the table below, file attached to this comment.
The table has 2 fields, Animal ID and Animal Group. There are 40 animals and 10 groups, each group should have 4 animals in it. The tricky part is that I want the animals with the lowest Animal ID to be added to the group with the lowest Animal Group value, but groups are missing different numbers of animals to be filled.
In this example group 1 is missing 1 animal to reach 4, so I want Animal ID 2 to go to Group 1. Group 2 only has 2 members so it needs 2 more, so Animal ID 7 and Animal ID 10 would go to Group 2. Is it possible to solve it without an iterative macro?