football

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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