Forum Discussion
AlanMaga
Feb 15, 2024Copper Contributor
Random assigning
Dear all, I need to randomly group people into groups of 2 as indicated in the picture and randomly assign an analyst to prepare documents for the particular groups with the help of excel functi...
djclements
Feb 15, 2024Silver Contributor
AlanMaga I'm a bit confused with the logic here. Are the QC Analysts always the same 5 people (shown in range J10:J14)? If so, then I'm thinking they shouldn't be listed in the same table as the other members, because the formula you're using in the ROUND column can end up placing two analysts in one group (as is the case with group 5 in your screenshot). If the goal is to randomly place members into 5 groups, then randomly assign an analyst to each group, the lists should be separated. Also, your XLOOKUP formula in cell C21 can probably be simplified with:
=SORTBY(J10:J14, RANDARRAY(5))
I hope that helps...