+ Reply to Thread
Results 1 to 1 of 1

Using LOOKUP for football data analysis

  1. #1
    Registered User
    Join Date
    08-30-2014
    Location
    Leeds
    MS-Off Ver
    2013
    Posts
    1

    Using LOOKUP for football data analysis

    Morning all,

    I have a spreadsheet that I use to log football results for all the major European Leagues. All the results are contained within one sheet "SS Results" and then i have an "Overview" sheet which extracts and displays some elements of the data that I wish to see.

    I am now wanting to add an extra three columns to the first table on the overview sheet. L6 (last 6), L6H (last 6 Home), L6A (last 6 away).
    The new columns need to check the results sheet and count the number of times the "BTS" column = 1 for the relevant team.
    Obvioulsy the parameters for each new column are slightly different - L6 needs to check the last 6 times the team played be it home or away - L6H needs to only check the last 6 times the team played at home - L6A (following a theme here) needs to check the last 6 aways.


    I have been toiling with this for a few weeks now, reading forums, trying various examples i can find etc but being the excel novice that I am, I really am struggling. I wondered whether anybody had any ideas to help?
    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. [SOLVED] Using LOOKUP ? For Football Data
    By Onceageordie in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 05-18-2014, 12:58 PM
  2. Football Data Analysis Optimisation
    By ormerods in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2014, 10:33 AM
  3. Logic Test / Lookup Formula Help - Fantasy Football
    By wazzap_nz in forum Excel General
    Replies: 3
    Last Post: 03-30-2011, 04:24 PM
  4. Logic Test / Lookup Formula Help - Fantasy Football
    By wazzap_nz in forum Excel General
    Replies: 1
    Last Post: 03-30-2011, 04:39 AM
  5. Replies: 3
    Last Post: 08-09-2010, 04:04 AM

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