Split dataset into two groups with minimum deviation on multiple values

Hi Excel Forum!

I have a really interesting task I am trying my best to solve, but I got stuck. I need an expert!

I need to divide a dataset into two groups with a minimum difference/deviation in each of the parameters used.

The purpose is to divide a country into two "equal" sizes to be able to apply some local initiatives in a select set of cities (one of the two groups) to see the effects.

I have tried two things:
1. Using choose+rand to assign Group A or Group B to each of the rows and then using Solver to get as close to 0,00% deviation for one parameter. However, this has the flaw of only covering 1 value/parameter - and it is highly imprecise.
2. I then found a VBA and tried to tweak it, but with no luck. It does a really great job of dividing into two equal groups (sum) but, the number of items in each group varies a lot. In other words, I could also only get this to work for 1 value/parameter.

I am not skilled enough to do anything that covers multiple values.

Can anyone point me in the right direction of what I should look into? This would be really helpful - and thank you so much in advance.


For reference I have pasted the VBA I found in another thread:

Please Login or Register  to view this content.

Off topic, but could you please clarify which 'latest' version you have and update your profile accordingly? Excel 2019 and Office 365 are not actually the same thing, and your version may influence solutions offered as we move forward. Thanks.

OK - please update your user profile stating that it is Excel for Mac 365.