Home

Random Teams from list of names

%3CLINGO-SUB%20id%3D%22lingo-sub-693918%22%20slang%3D%22en-US%22%3ERandom%20Teams%20from%20list%20of%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693918%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20random%20teams%20of%20two%20from%20a%20list%20of%20names.%20I%20have%2025%20names%20but%20only%20need%2010%20teams%20(20%20people).%20I%20have%20a%20total%20value%20of%20how%20many%20times%20each%20person%20has%20been%20on%20a%20team.%20I%20want%20the%20new%20teams%20to%20be%20created%20based%20on%20the%20opportunity%20to%20be%20on%20a%20team.%20Example.%205%20of%20the%2025%20people%20have%20been%20on%20a%20team%205%20times%20but%20the%20others%20have%20been%20on%20a%20team%204%20or%20less.%20I%20want%20the%20new%20random%20teams%20to%20be%20created%20only%20with%20people%20who%20have%20been%20less%20than%205%20(an%20automated%20process%20fed%20by%20formulas).%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-693918%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
PeterKTO
Occasional Visitor

I want to create random teams of two from a list of names. I have 25 names but only need 10 teams (20 people). I have a total value of how many times each person has been on a team. I want the new teams to be created based on the opportunity to be on a team. Example. 5 of the 25 people have been on a team 5 times but the others have been on a team 4 or less. I want the new random teams to be created only with people who have been less than 5 (an automated process fed by formulas). Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies