HI Bsalomons,

welcome to the forum.
See the attached file and click on blue button to generate the random team members without duplication (will take some time to process)

random team generation.xlsm


Regards,
DILIPandey
<click on below * if this helps>