football

  1. E

    Ranking and probabilities about games and league table

    Hello everyone, I need your help to answer these questions on which I have spent a lot of time but am not making any progress... Construct the current League Table - ordered by points (3 for a win, 1 for a draw), goal difference and then goals scored. Produce prices for the upcoming fixtures...
  2. D

    Yards per rush calculation

    Been working on a stats spreadsheet and cant figure out how to calculate total rush yards and yards per carry for the running game. Hopefully someone can help me out. My sheet is below: ABCDEFGHIJKLMNOPQR1Team Stats:19002Player NamePlayer NumberTouchesQ1Q2Q3Q4CarriesTotal Rush YardsYards per...
  3. D

    Football Stats Help!

    Hi, I am an offensive assistant coach and I'm looking for some help on tracking statistics for the offense. I need to capture things like the number of touches our offensive guys get, the number of yards gained per play, completions, passing yards, 3rd down conversions, 4th down conversions...
  4. N

    Mock Draft Accuracy Functions

    I need help figuring out what function to use in order to assess the accuracy of a mock draft based on a point system I found online. I created 2 sheets: Sheet 1= which contains the actual results of the upcoming NFL Draft (which I will update as picks are made) and Sheet 2= the predicted...
  5. B

    Vlookup with multiple occurances, return a "Y" if the value appears at least once

    Hi all - thanks in advance. I think this is fairly straightforward with an array formula but can't get it to function. If I have a column that has multiple occurences of a word, and the second column contains either a "n" or a "y", if any of the the occurences contain a "Y" I want the formuala...
  6. S

    football table

    https://1drv.ms/x/s!Aq3WqOz73fYygYUinBF1m9sbdkyMaw?e=c78rMA I have created the above file, but I am trying to modify it, so I can record goal scorers, for each game. I want to see how to make it better, any ideas please. Regards Stephen
  7. W

    Building a fantasy football board

    I am building a fantasy football board. The board is finished and working, but the next step into it would be having the players fall off the list on the individual positions sheets once selected. i am having trouble with it and any help would be appreciated.
  8. L

    IFERROR & VALUE Help (need to convert numbers from text to value, but when there is a space instead of 7 there is a 07 it doesnt work.)

    Hey Folks, Newbie to the community here, trying to update weekly football scores that i copy and paste from a website. (covers.com) The football scores come in this format W/L (win or loss) and the score with a hyphen in the middle. "L 31-33" would be a loss as the team scored 31 points and...
  9. M

    Matching cells

    Hi again All!I have a worksheet - column A is a list of actual football scores in the format digit.space.digit such as >1 1<.Column B is a list of score predictions, in the same format.Column C is looking for identical matches - i.e. where the score is an exact match and I use the following...
  10. ECB

    Find first instance of value in a range.

    Hello all, I hope you are well. It's been a while since I was here, and Google has been my friend but I'm really struggling with this one. I clearly can't see the wood for the trees because this seems so simple. I have a spreadsheet. In Column A I have my marker column 1 to 5000. In columns B...
  11. S

    Football Statistic Match Ratings (Average for Past 3 Games)

    I'm building out a database of Football statistics for the Football Teams I support, however an issue I have is that it is all automated, except for the average rating for the past three matches (Recent Form). At the moment I have to manually select the cells that would contribute to this...
  12. M

    VBA replace letter and number

    I'm trying to remove an occurence of a letter and number from a string, the number may or may not appear in the string, It'll be in the format T1,T2 etc in a string like so Football T9 something else I'd just want the string changed to Football something else It'd be used in a UDF if that...
  13. E

    Three Criteria for an If Statement

    Hi All, In column A I want to check for "Liverpool Football" and in Column B I want to check for the words "Football" or "Sport", if this criteria is met I want "yes" returned otherwise "no", how can this be done? Thanks
  14. E

    Returning Cells Based on Values

    I have two tabs namely "Working" and "Source" but I need to do the following: 1. In the "Working" tab I have a list of unique IDs in column A, I want to match these with Column A of the Source tab which also contains IDs. 2. Once the corresponding ID has been found in the "Source" tab I want...
  15. F

    Quarter final result convert to semi final

    Hi, i'm doing a football spreadsheet, I need a formula that will recognise P in column A3 to put Manchester into the next round and appear in Column A5 Whilst if No "P" appears it will pick the highest score from either A4 or A5 to put through to the next round <tbody> Manchester 2 P...
  16. F

    Random Draw

    I want to create a champions League style group draw if possible through spreadsheet As i'm a beginner to excel I don't have a clue how to do this and I am willing to learn if possible I have 16 teams in columns A1 to A16 I have a seeded section ranging from 1 to 4 with the aim of creating 4...
  17. F

    Win or Penalties change

    Hi, i'm doing a football spreadsheet, I need a formula that will recognise P in column A3 to put Manchester into the next round and appear in Column A5 Whilst if No "P" appears it will pick the highest score from either A4 or A5 to put through to the next round <tbody> Manchester 2 P...
  18. F

    Football Knockout Help

    Hi, I'm struggling with a spreadsheet i'm doing at the minute. I've got a football tournament with 4 groups of 4 at the minute I've done this so the top team goes through to the knockout stage from each group, located in G14, G34, G54 and G74 I've also done the 2nd team in each group to go...
  19. I

    Looking advice on combination entry football win draw formula

    Hi all, Hopefully this makes sense, i currently bet on football using a combination of win or draw. So if i bet 5 teams to win and draw there are 32 combination bets for example my first 5 may be draw draw draw draw draw then win draw draw draw draw and so on is there any formula i could put...
  20. 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...
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 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
Top