football

  1. F

    Formula Issue

    Hello People, I'm stuck and need a little help if possible. The table below shows a list of Results (Not actual grid references, but I can hopefully edit if problem is sorted) which are on Sheet 2 of my spreadsheet. <tbody> A B C D E F G H I 1 Home Score - Score Away...
  2. F

    Pivot table and data issues!!! HELP PLease

    Anyone!!! I have been attempting to create some spreadsheets for fantasy football, to help better determine which players to draft. Anyways I have worked with excel many times before. However, the raw data I have that basically has all players from 2008 -14 listed in the spreadsheet. I have a...
  3. R

    Football Ladder predictions

    I have started a football ladder prediction competition. In it, the tippers have to predict the correct order that the 18 teams will finish in. It works on a points system where a tipper gets one point for every place they are off the correct position. e.g. If a Tipper predicts Sydney to...
  4. T

    Using Solver Add-in for a Linear Program: For Fun Fantasy Football!

    I thought it would be fun to make a linear program for fantasy football. Background information: You pick 9 players; 2 quarterbacks, 2 running backs, 3 wide receivers, 1 tight end, and 1 flex (running back, wide receiver, or tight end). Each player has an associated cost. You're capped...
  5. C

    Football: If statement search range and return specific value

    Hello, I am building a spreadsheet for a football pool. I have a range of cells with the game winners and a cell with the person pick and point value. In one cell the formula should search the range of game winners and see if it equals the pick and assign the point value if true. The points...
  6. M

    Better way of picking out maximum values with corresponding text

    Hello, I am looking for help with a spreadsheet that I have set up for local football teams, specifically with picking out maximum values and corresponding text cells (i.e. top goalscorer, most goal assists, yellow cards etc.) As it stands, I have done it like this (using top goalscorer as an...
  7. J

    Cut up a String into different cells

    Hey I am a football coach we use excel to script our practices. I want our long script string to be broken up into separate columns. Here is an example: In excel I have: 1 split H Across 67 Hitch Rt I want to split up the Formation (1 Split) the motion (H Across) the hole (67) and the play...
  8. A

    Football Data - Analysing recent team form (I have half of the solution in SUMPRODUCT)

    https://drive.google.com/file/d/0B0csbmxO50sARnlNd203a1MyMzg/edit?usp=sharing Above is a link to the Google Drive doc for this post I'm trying to sum together goals scored for and against for a particular team in the previous X number of games played. The doc shows home teams in column F and...
  9. I

    IF Formula help needed - football results spreadsheet

    Hi there, I have just found this site and hopefully someone can help with them problem im faced with. I have one sheet within the workbook with the Table shown below where I track the football results from all English and Scottish leagues. <tbody> WEEK HRES HSCORE HOME AWAY ASCORE ARES...
  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. B

    VBA code to get a value from 2 matching cell filled with color

    hello, i dont know much about VBA coding but if anyone is willing to help, i run a predictions league and i would like to be able to make a code so if the home teams scores 1st and the person who predicted the result put the home team to score 1st too, i get a value of 2 points, if the results...
  12. B

    Need advice with this formula for my football predictions

    Hey, I run a football (soccer) predictions league for me and my friends and after so many years of doing it all manually i want to make it work with formulas but i cant get them to work properly, im very close to completing it but theres always 1 result that doesnt work properly. Here is the...
  13. B

    American Football Formula Help Needed!!!

    What I am trying to do is assign a range of values a name. I have data from a football game such as down & distance, yard line, gain/loss etc.. I want to use a formula to configure "Field Zones" for certain yard lines. For example, when I create a Field Zone collumn to the data I have and...
  14. H

    Football Statistics Yardage

    I have a Workbook with several spreadsheets in it that I use to stat our games. With the help of someone on this board I was able to create this; sorry I don't recall whom it was, but it was whomever listed the sheets with SUMPRODUCT for football. Now I am trying to add a little convience to...
  15. A

    Fantasy Football Head-to-Head Formula

    Hi Everyone, I'm hoping that someone might be able to help me or at least make my life easier. I run a fantasy football competition and at the end of each year I update a table that show's the head-to-head record of the teams in the league (Website link: http://goo.gl/3Jec5). The only way I...
  16. Lensmeister

    New DB setup help

    Hi all, I hope someone can help me out with the various problems I am having with my (almost) new project. I am recording a football club's history. Currently it is in Excel, but I was hoping to draw it into Access and make it report and query better for things like stats etc. I need some...
  17. J

    Football pools

    Need help to create excel worksheet which gives me facility to choose how much i want to emphasize every sign in football pools. Here is the example. There is 13 match in every coupon. 1. 1X2 I want give home league 70% chance to win, 20%to tie and 10% to away win 2. 1X2 I want give home...
  18. B

    Games PLayed in Football Table

    I am organising a world cup themed tournament. So far i have worked out different lookup formula to work out goals scored, conceded, points obtained. So when new scores are entered it automatically updates the table. I have a macro that will automatically sort the tables in the correct order...
  19. D

    HELP.. Need to write a formula

    Hi All, New to this but i heard this was the place to find answers to my excel questions. Ok so here is what i am trying to do. On one sheet it has a table which has the results to football games On the same sheet it has the peoples predictions On the second sheet it has a League table. On the...
  20. M

    Sorting a list automatically by changing details...?

    Hi people, I have just recently managed to create a quiet sensible football league table where the table gets generated automatically by entering the results of the matches between the teams. What I need is whether it is possible to sort the table automatically after filling in some results of...

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