@Andrei35 Excel could be helpful but won't just do it for you per se. That said you need 100 teams of 11 players (total of 1100 slots) and have 150 players with a max of 7 per individual (1050 slots max). It would appear you have a problem ...
That said, I think you could have your list in col A then create a col that has that list repeated 7x with each in a random order. The every 11 rows becomes a team. Again, as of now, you don't have enough players.
In the attached sheet I have a col for player names (col A) and then col B has that list randomized 7x the number of players in col A. The random numbers are on sheetB BUT what I did was use cols A:G to generate random numbers and then copied those numbers onto cols H:N as VALUES so the order doesn't keep changing every time you hit enter on the sheet. To create a new list simply copy the values from cols A:G and paste as VALUES onto cols H:N
I added the letters a:z as player names (26 total) and filled col B with the formula down to row 200 but you will see that after row 183 (26 x 7 = 182 + 1 because it starts on row 2 = 183) the values show #N/A because you ran out of players. You will have to fill down to row 1101.
I created a easy to read list of Teams labelled Team 1, Team 2,... to show that portion of col B in a convenient display (i.e. Team 1 is rows 2:12, Team 2 is rows 13:23, etc...). Again you will have to fill right to create the rest of the teams if you want that format.
Hope it works for you.
EDIT: Hi @Bennadeau , I just saw we both worked on this question at the same time and both found the number of players short. I'm sure between us Andrei should have something that works. :)
