Forum Discussion
Solved
Split uneven teams into new groups
Hi all, Excel 2019, ideally no VBA. I currently have 12 groups with uneven numbers or members (total 100) i.e. G1 - 20 G2 - 19 G3 - 14 G4 - 12 G5 - 8 G6 - 7 G7 - 6 G8 - 5 G9 - 3 ...
AWilkiie Attached a workbook with two possible solutions. One using PowerQuery, the other standard Excel. Both use a randomizer to redistribute persons among 8-9 members groups. If you don't like the distribution, press Refresh All on the Data ribbon and the grouping will change instantly.
See if either of the two could work for you.
AWilkiie Attached a workbook with two possible solutions. One using PowerQuery, the other standard Excel. Both use a randomizer to redistribute persons among 8-9 members groups. If you don't like the distribution, press Refresh All on the Data ribbon and the grouping will change instantly.
See if either of the two could work for you.
Thanks for this. PQ isn't something I use much. I hadn't thought of the MOD function.