+ Reply to Thread
Results 1 to 8 of 8

How to insert a previous Head to head matches ?

  1. #1
    Registered User
    Join Date
    04-15-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2007
    Posts
    16

    How to insert a previous Head to head matches ?

    Hello

    I've a excel file for sport games. Right now i'm working on a specific game , the AFL.

    In this file, i have a sheet with the games ( Sheet Jogos ) and i've the sheet data with all the games since 2009.
    I'm trying to show all the head to head previous matches between 2 teams.

    Example:

    At 15 May , i've 9 games in the sheet Jogos, changing the date , it changes the games . The first game is North Melbourne vs Essendon. In the sheet Data , i've all the games played in past seasons and i want a formula to show only the previous head to head matches for all the 9 games defined in th sheet Jogos.

    I attached the file.

    Thanks in advance
    Best regards
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: How to insert a previous Head to head matches ?

    Hi

    Data sheet
    A3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Copy down.

    Head to Head sheet
    C3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy down.
    D3
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Copy down and cross.

    See the files

    Regard
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: How to insert a previous Head to head matches ?

    Some reason it didn't submit!!! Try again.

  4. #4
    Registered User
    Join Date
    04-15-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: How to insert a previous Head to head matches ?

    Thanks , it worked like a charm.

    And how can i replicate for all games ? In Head to Head Sheet it has only one head to head , how can i create 9 ?

    Once agian , thanks :-)

  5. #5
    Registered User
    Join Date
    04-15-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: How to insert a previous Head to head matches ?

    See the new attachment , sheet Head to Head , all the 9 games. I've tried to copy/paste but it didn't work
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: How to insert a previous Head to head matches ?

    Hi

    Data Sheet
    Add 8 extra column A:J! In order get 9 head to head all 9 games.

    See the file

    Regard
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    04-15-2013
    Location
    Lisboa
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: How to insert a previous Head to head matches ?

    Micope21 , YOU'RE THE BEST .... thanks

    Best Regards

  8. #8
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: How to insert a previous Head to head matches ?

    You welcome!

    If this is solve? please go to top page and click Tread tool, then click solve!

    You happy with it please click left side Add Reputation!!

    All the best.

    Regard

+ 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. League Table Based on Head to Head results
    By darkblueblood in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2023, 07:10 AM
  2. Breaking ties in a head to head contest
    By cklemme in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-28-2014, 01:06 AM
  3. How to account for head to head matchup in Excel with other tie breakers
    By Biogeek1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2013, 05:18 PM
  4. Calculate average of last two outcomes of last two head-to-head clashes
    By wishkey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 08:17 AM
  5. Ranking a league table by head to head results
    By pajc72 in forum Excel General
    Replies: 1
    Last Post: 09-02-2011, 07:02 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