View original (French)

Name mix to form teams

Solved
GEPSA Posted messages 56 Status Member -  
Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   -
Hello,
I have a total list of 136 names. This list consists of employees from different sites. I would like to create game teams by mixing the names. Thank you for your help.
Best regards.

3 answers

  1.
    Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    It's very easy: You do it like for the draw for international competitions!
    You put the 136 names on pieces of paper and place them in a hat, and you ask an innocent hand to pick the papers one by one.

    The most complicated part is finding this innocent hand ...
    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. GEPSA Posted messages 56 Status Member
       
      Hello, yes of course, that’s a solution! But it’s not the answer I was expecting... it’s a list in an Excel file, and I know there’s a simple formula that I don’t know, which allows you to select the list and shuffle it to then separate it into teams.
      0
  2. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    Your question was cleverly (?) posed in the forum Leisure/Entertainment, and the word "list" could apply to PowerPoint, Word, Calc, Writer, so we could not possibly guess that you were talking about Excel!

    --
    Retirement is nice! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. GEPSA Posted messages 56 Status Member
       
      Sorry for misexplaining my problem. While searching, I found the solution with the RAND function.
      Have a nice day in the sun.....
      0
  3. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    No, there is no simple formula that can both mix names and extract name groups.
    If you do not specify the number of people per team, if you do not indicate the criteria by which the teams are formed (men/women - multiple sites - etc.), we will have a hard time proposing a solution for you.
    However, you are a regular on the Bureautique/Excel forum: you know that a problem can only be solved if we have enough data...

    --
    Retirement is great! Especially in the Antilles...
    Raymond (INSA, AFPA)
    0