+ Reply to Thread
Results 1 to 23 of 23

Football/Soccer data, teams giving up a lead or recovering a goal deficit

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: Football/Soccer data, teams giving up a lead or recovering a goal deficit

    Hi Alex,

    I'm working on something that might or might not be what you're after, see attached.

    Row 2 are the times (in minutes) of the goals by both teams.
    Row 3 works out the sequence of the goals being scored and show in Rows 5&6.

    Row 9 works out the nett goals (Home-Away).

    Cell V9 works out the max home lead and V10 for home deficit.

    Also, Cell V4 works out max consecutive home goals, likewise V5 for the away team.

    So, once Row 2 populated for that particular match it should be able to see if the team throw away a commanding 'X' goals lead with 'Y' no of consecutive goals etc.

    What do you think?

    Alan
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 12-21-2013, 07:57 PM
  2. [SOLVED] Football (Soccer!) points scoring
    By Onceageordie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2013, 10:22 AM
  3. Processing football(soccer) results
    By teacherphil in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-11-2013, 10:02 AM
  4. New Football (Soccer) Season
    By Domski in forum The Water Cooler
    Replies: 25
    Last Post: 07-26-2011, 11:17 AM
  5. Football (soccer) predictions formula
    By genius7082 in forum Excel General
    Replies: 4
    Last Post: 08-12-2008, 10:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1