in one column enter groups of team designation so that each team designation
is listed the same number of times as there will be players.
Either next to this column or next to the column of palyers names enter in
the top cell
=rand()
copy this down to have one per player.
Select the set of random numbers and either the team designations or the
players names and sort by the column of random numbers. The playyers will now
be randomly associated with a team.
Use brute force, use a help column and put =RAND() and copy down the same
number of rows, then just sort by the help column
Regards,
Peo Sjoblom
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.