teams

  1. J

    Avoid back to back Match ups

    Good morning I am running a dart league here are the details 12 teams (Team1, Team2, Team3...etc) 2 Division (odd teams and Even Teams) 16 weeks 6 Boards (all teams play at the same time) I would like the teams to play in the same division 2 times, while playing the opposite division 1 time...
  2. G

    Return two values from a separate list

    Hi - I am trying to create a sheet for my company football pool (sorry if the topic is silly). For each pool member they have their own sheet and each personal sheet has a list of teams and values. The team list in column B is each NFL Team. The value list in column C is a data validation...
  3. B

    Random Teams with Excel formula

    Trying to use a list of 2 man golf teams then randomize four man teams (foursomes) without repeating a name nor using their two man team partner on the same foursome. The list of 2 man teams can decrease or increase. Can this be done with an Excel formula without using vba ?
  4. E

    which teams were removed

    Hi, I have a long list of soccer teams in each cell example like the one below from a website data. B1 LIVERPOOL B2 CHELSEA B3 ARSENAL B4 MAN UNITES etc... Once a week I udate data by pressing, data, refresh all, so teams will change from week to another. I want a formula that the new...
  5. F

    Amatour coder needs help cleaning up code

    Hi guys most of my script has been created based on Q and A here and all the help I've received is much appreciated. I have been able to create a script that does what i want, but my code is real messy. I was hoping someone have a better solution for this code: 'Home and away teams...
  6. F

    Random Team Scheduler Over Multiple Weeks

    <body> <p>Hi All,</p><p>I need help trying to make a team scheduler for a non-profit league using XL2003/7. I need to pick random opponents over an 8 week period for each team with no team playing each other more than once, and only playing one game each week. The number of teams can vary...
  7. S

    Randomly selecting names

    I want to use a spreadhseet to create random teams for a project. Here's the scenario: -1200 possible team members listed in column A -500 teams listed in column B -4 people on each team ready to be populated in columns C-F -End goal is to have every team member makes it on at least 2 teams...
  8. B

    Random Team Generator allowing Duplicates on separate teams

    Hello: I am working a rodeo benefit that allows people to enter up to 2 times for an event. I need to have all of the members randomly assigned to teams of 4 without pairing them with themselves since they can be on 2 teams. I will have all names in Column A, and the number of teams will be...
  9. P

    Can you create balanced teams?

    Hi all, I have "x" categories of different sizes and would like to create "y" teams with the same proportion of each category in it. Also I need the teams to be of equal size plus or minus maximum one individual. For instance, let's stay I have 3 categories: Bachelor's, 8 students; Master's...
    • paseo
    • Thread
    • condition data categorization group by table teams
    • Replies: 0
    • Forum: Excel Questions
  10. G

    Problem to Team List

    hey every one, I have a team list where each team has around 12 -17 members. Now using Data Validation I have put the team name in a single cell. Now what i want to do is when ill select a team from the list, i want the team members info in the below table.
  11. L

    Consolidate list into teams across columns...

    Sorry for the cryptic title: Basically I have a list as shown in "INPUT" below and I want to have it automatically convert into the "OUTPUT" below. It basically separates out the ID#s under their respective team names. The way I thought I could accomplish it would be to have it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top