1. S

    Winning combination team for soccer players

    Hello All, Thanks for having this wonderful forum and I request your help with a small challenge of mine. I am new to excel and not sure if excel can do this at all, but I give it a try. We have a small team of players(around 30) out of which around 20 who come every week to play soccer. The...
  2. G

    Fantasy Football (Soccer) League

    Hi everyone, I have a very basic understanding of Excel and have seen a few YouTube tutorials on formulas etc. however what I am looking for is some help on this fantasy league I've created, It's a 10 team league based on the 2021/22 Premier League fixtures. I want to be able to input the office...
  3. C

    10% Time Improvements

    I am trying to use a formula to calculate 10% time improvements on my student's mile run times. I came up with a workaround to split the minutes and seconds into different cells, convert them into total seconds, multiply by .90, then divide by sixty to get Min.Sec. Not fully working though as I...
  4. N

    how to built a prediction sport betting model with excel?

    is there a book i can read or someone who does lessons on that? what i need is to insert the soccer data,and after using formulas like poisson.distr. to give possibilities for certain outcomes
  5. Alphacsulb

    Countif Table

    Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...
  6. B

    All variables for 8 soccer matches

    How many possible outcomes are there in 8 soccer matches
  7. S

    Need help with my Soccer Team generator

    I help run a pick up soccer league in my hometown and we are always arguing about unfair/unbalanced teams so I am praying someone on here can help me come up with a macro to solve this. I have created this spreadsheet -!Ailn0TMJeSXLidw46xoEz-WElsxGaw What I am hoping is...
  8. J

    How to Transpose large data in Excel?

    Hi all-- I need help on how to transpose a large set of data which contains: year, term, student id, and sports. It gets complicated because there are some students that played multiple sports each term. Here's what the raw data looks like: <tbody> YEAR_CODE TERM_CODE ID NUM SPORTS...
  9. N

    Soccer Results- Combine Two Sets of Results

    Hi Folks Just wondering if someone can help me speed up a process. In the attached sheet you will see some sets of soccer results which I type in as text on sheet 1. What I want to do is combine the sets of results from both teams in order to find the most likely scoreline at full time,and...
  10. M

    Simple if and question

    I am after a formula that tells me if a bet I have placed has won and in what way. It is to do with Asian handicap betting. I shall explain more. I have a bet in a1 that I have made. It may be -1, which means that I have bet on the away team to win by 1 or more goals. It could be a positive...
  11. T

    Web data source iframe

    Hi everybody! I'm a novice when it comes to vba and using external data. Can someone please tell me how to get the data from the following web source: This is a secure norwegian gaming website from "Norsk Tipping" - the only legal betting company in...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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