1. T

    Unique Pairs for 12 Players

    Hi All, I have a maths question I need your help with. I'm trying to generate 12 unique pairs for Badminton Doubles to not have the following: Player 12 not playing Player 4 three times (example Game 4, Game 5 and Game 6) Player 5 not playing Player 7, 8 and 11 more than once such as 7,8...
  2. X


    Hello Friends, please help me, How do I calculate the same result, which is next? for example: result=What formula to write to count the result 1= How many games have won a step by step? 2 = How many games have you lost in step by step? 3 = How many games have played a draw step? <tbody>...
  3. C

    Anybody any good with Array formulas?

    Hi I am trying to create a dashboard that gives me the top 5 (and bottom 5) on a number of key metrics. I have put an example table below, but I trying to create a result that will list in order 1-5. Please assume Category is column A, Product is Column B, etc...
  4. D


    Hi, I'm looking for how to create a win or lose (no ties) combination in an excel for 16 teams and 8 games. I know there are 256 combinations, but how can I have this combinations listed in excel? Thanks in advance Damien
  5. W

    Seeking advice on where to begin - Searching for team form football data

    Hi guys and gals. At this stage Im not looking for a specific solution to a problem but rather ideas on how to approach something. I have several spreadsheets of football data covering several seasons of results and odds. eg: <tbody> Date HomeTeam AwayTeam Home Goals Away Goals Result...
  6. A

    Wins + Losses for Sports Teams at Different Points

    Hi all, First time posting and looking for some help regarding a set of sports statistics. I am looking to analyze the effect of home court advantage in the 2018-2019 season and wanted to be able to control for how many wins each team has at a certain time in the season. I currently have a set...
  7. P

    Dropdown list not matching conditional formating on list, need a solution.

    Hey All, I'm trying to track what games friends have vs what games I have, etc, so I decided to use Excel and make a list, etc. Then when the weekend comes I can just look who is around and decide on a game we are playing. When I do a drop down list to allocate the game names to the person...
  8. S

    Generating Random Teams While Rotating Players In

    Hi All, I ran into a wall and hope someone can help. I currently have a clunky spreadsheet that will randomly distribute 16 people into 4 teams of 4 for our volleyball games. What I actually need to do is for the spreadsheet to distribute 20 people into 4 teams of 4, and hold the 4 remaining...
  9. L

    VBA find header and clear contents

    Hi good people!, Please assist me with this: Sheet1 = Database Sheet2 =View Sheet "Database" has the following: A1 = "01-01-2019" A2 = "Handle" B2 = "Win" C2 = "Games" D2 = "Theo Hold" Then E1 = "02-01-2019" E2 = "Handle" F2 = "Win" G2 = "Games" H2 = "Theo Hold" and so the pattern goes...
  10. C

    Baseball / Hitting Streaks - Conditional Formating

    Below is a snapshot of my spreadsheet. All numbers (hits) are populated (linked) from other sheets in workbook depicting each specific games. The GREEN background seen is currently being formatted manually. I am now trying to figure out how to CONDITIONALLY FORMAT the cells to show a players...
  11. B

    "MaxIF" or "RankIf" formulas?

    Is there a formula to find the highest score(s) for Bob in a list with all of his games, and all of his teammates games? Something like "MaxIf" would be perfect, but I don't think it exists. It seems logical, but I'm stumped. If that is possible, can it be taken a step farther to have a...
  12. V

    Fixture Creation Advice

    Hi everyone, (New here so go easy on me please). I need to create a fixture list (home and away) that can adjust to different number of players but there's one difficult part: we need everyone to have as many home games (or away games) in a row if possible and all teams must play at the same...
  13. C

    Review Chess Moves and Times by importing in Excel

    I play online Chess games with various opponents.....On completion.....these games are saved on the Website's page.... So after accessing the source code, I can get the text code of the game that I played in the following format.... Every move starts with a left curly bracket and ends with a...
  14. S

    Best formula to use

    Hi Guys, I would be very grateful if anyone can help me with the best formula to use on this one. I help coach with a junior football team and we have a squad of 15 players, but we can only select 10 on a match day, and there are 18 games during the season. Whats the best way to put a...
  15. M

    Create an Excel VBA form using a loop to source the inputs

    Hi, I have a list of soccer games on sheet "Web Import" with team A in column C and team B in column E. I want to create a user from for a user to input scores for these games. So when the user form pops up (once the spreadsheet is opened) it should present the user with the teams from the...
  16. J

    Sports scheduling helper

    I have a simple scheduling table to determine 16-game schedules in a league of 32 teams: The teams are numbered 1-32. The games in the red triangle are all the unique games (everything repeats on the other half). A team's schedule can be read across or down...
  17. 1

    form data, how did a team perform in the last 6 games

    Hi Guys, I have a spreadsheet with lots of football scores, I have attached it so you know what I'm talking about. Here is one of the entries, <tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;"> Ref Output Home Away HTHome HTAway Date FTHome...
  18. B

    VBA to Find and Replace Text from a cell

    Hello friends i have a sheet as below- In Sheet 1 Column A Column B Company Name Example Inc. Games Football and Swimming In Sheet 2 I have a sheet having thousands of sentences in Column A Eg- ABC Inc is a very big company. ABC...
  19. L

    Score table for world cup 2018

    Hello fellow Excel:ians. I have some issues with my score table for world cup gamble predictions for my friends and colleagues. I want to keep a track of the scores, group scores and so on. I have made 12 sheets, which include all Groups A-H (8). 1 sheet with all of the score tables, 1 sheet...
  20. W

    Complex "COUNTIFS" calculation

    Dear all, Please advise, is there any way to calculate the following task with excel? In document, There are 3 players. We are playing pingpong games. Each day we play two tournirs. In each...

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
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 "".
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