Assign participants to groups based on their preferences

%3CLINGO-SUB%20id%3D%22lingo-sub-2265287%22%20slang%3D%22en-US%22%3EAssign%20participants%20to%20groups%20based%20on%20their%20preferences%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2265287%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20organising%20an%20event%20for%20400%20participants%20and%20I%20need%20to%20assign%20all%20these%20participants%20into%2010%20different%20company%20workshops.%20The%20participants%20have%20all%20given%20their%20preferences%20for%20their%20top%203%20workshops.%20Does%20anyone%20know%20if%20I%20can%20use%20excel%20to%20help%20me%20to%20easily%20assign%20these%20400%20participants%20in%2010%20groups%20of%2040%20based%20on%20the%20preference%20of%20the%20participant%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2265287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello, I am organising an event for 400 participants and I need to assign all these participants into 10 different company workshops. The participants have all given their preferences for their top 3 workshops. Does anyone know if I can use excel to help me to easily assign these 400 participants in 10 groups of 40 based on the preference of the participant? 

0 Replies