Can someone help? I need help figuring out how to evenly distribute things. I have 72 objects each with 6 of 27 boxes checked. I need to split those into 2 groups that are equal across all 27 boxes (should be 8 in each).
Actually, if the checkboxes must be evenly divided into 8 in each set, then the maximum number of possible combinations is 27 times 16 choose 8 = 347490. You could find that by brute force on a computer.
Couldn't you just write some rules and that would enter the values into another sheet under the categories you need? It's probably more labor intensive than you would like, but that's all I can think of. I know jist enough to be dangerous in excel, so there is probably a better way...