My mom is in charge of determining groupings for her golf league down in Florida. There's anywhere from 18-44 people who play, and her goal is to get the groups (can be either threesomes or foursomes) as equal as possible based on handicaps (said another way, having the cumulative handicap of each group be as close as possible to the other groups). To do this, she assigns a random number to everyone playing and creates groups that way, and then refreshes the sheet to try and get the delta between the lowest and highest groups to be less then two (not sure why that's the arbitrary number). Anyhow, I've been trying to automate this via combining the random number generator with the solver function but having no luck. Anyone have any ideas or avenues to go down? Here's some shots to show the current logic (highlighted cell is the delta between the min and max in column I). At this point I'm kinda at a loss for how to handle other then writing some VBA which cycles through and refreshes the random number function until a certain value is captured in J1.