This interesting problem showed up in the Excel Reddit so we posed it as a problem in the General BI Facebook Group.
Given the list of items on the left, how to divide them into three groups as equally as possible by weight? It doesn’t have to be the same number of items in each group. Just the closest match for weight across the three columns. The image is from Excel but show a solution in whatever tool you think is the best.
We’ll present the solutions that were submitted in the Mini-Conference this Thursday!
After that we’ll post any solutions here.