+ Reply to Thread
Results 1 to 4 of 4

Maximum Number of Players Per Team is 15

  1. #1
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Maximum Number of Players Per Team is 15

    Hello,

    I have a Team Generator! sheet that will create teams by selecting the green shape 'CREATE TEAMS'. Based on the Number of Players in T2 and then selecting the Number of Teams in T4 how can this prevent more than 15 players per team?

    I really appreciate any help,
    XJ

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Maximum Number of Players Per Team is 15

    hi XJ,

    I have to admit I did not evaluate the entire code, but at first glance you need to do 2 things...

    First of all, cap the teamsize at 15, by replacing:

    Please Login or Register  to view this content.
    with:

    Please Login or Register  to view this content.
    Which then will introduce a new problem, since a lower part of the code is designed to keep looping until it runs out of players (indirectly)? Of course not all players are guaranteed a spot if you limit the team size to 15 (if there are 8 teams for example and 150 available players. For that you can just exit the for loop if the team quantity is reached (the line in red does this):

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: Maximum Number of Players Per Team is 15

    Thank you that is exactly what I wanted.

    I do realize that not all players will be selected if there are a few teams chosen.

    It is amazing how you guys can do code so well.

    Happy Holidays!

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Maximum Number of Players Per Team is 15

    Glad I was able to help you

    Thanks for marking the thread as solved, the rep, and the feedback (including such a nice compliment!)

    I hope you too have a great holiday season!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Team Players
    By xjohnson in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2018, 09:05 AM
  2. Replies: 2
    Last Post: 04-11-2014, 12:41 AM
  3. Formula to pick players on a fantasy golf team
    By tahoeast in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2013, 09:37 PM
  4. How would I pick random team players using a 1 to 5 rating sys?
    By irish257 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2010, 06:12 PM
  5. [SOLVED] difficult:sort list of players by team from player list on separate sheet
    By Biff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1