Share via

How do I create a random roster

Anonymous
2013-01-19T01:15:11+00:00

This may be an advanced question and need help finding reference material to work this out.  I am creating a team roster for a golf league.  I need to create 8 teams of 4 players for 8 weeks and do not want any player to play another player more than one time.  I thought of using the rand formula then the lookup formula, but I keep getting duplicates.  How can I accomplish this without duplicates?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-03-26T03:28:40+00:00

    its  a red x . cant view the screenshot

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-01-20T21:25:58+00:00

    Here is the screenshot

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2013-01-19T19:14:04+00:00

    Hello,

    Off-topic, but I have proposed this solution to pair the 8 teams in a fair way (almost same strength):

    https://dl.dropbox.com/u/6077606/8Teams\_Size4.xlsm

    Regards,

    Bernd

    Was this answer helpful?

    0 comments
  5. Anonymous
    2013-01-19T17:53:34+00:00

    Was this answer helpful?

    0 comments