Create 2 teams at random based on win percentage

  • Hi I’m new to this. Please can someone help. I am trying to create 2 teams each week from a list of players. the players have a win percentage next to their names. What I want is to be able to pick 2 even random teams each week based on the win percentage. Can anyone help with how I go about doing this?

  • Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

  • Do the win percentages average to .5? i.e. are these percentages derived only from between the players on the list or are outside events included in the calculation of win percentage?

    Creating two teams with equal win percentage totals might not be possible, how much variation between the resulting teams is allowed?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!