+ Reply to Thread
Results 1 to 2 of 2

Golf League Scheduling Analysis

  1. #1
    Registered User
    Join Date
    06-18-2015
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2013
    Posts
    2

    Golf League Scheduling Analysis

    Hello and a sincere thank you in advance. I am using Excel 2013.

    I am trying to analyse our golf league matchups - schedule. We are using some software that just randomized the matchups and the time slots. There are certain teams that play others too often and others not enough or at all. I am trying to identify which teams have played (or will play) which and how many times.

    I am struggling to capture the match counts. There are 14 weeks and 10 teams. I have two columns representing each team per week and I want to get a numerical count of when they play another team.

    I know that team 1 will play team 2 twice in this schedule. I am trying to figure out how to show that via formula. I've tested the following formula (over the span of the two weeks that I know they played) but it isn't working properly.

    =SUM(COUNTIFS(L2:L6,{"=1,2"},M2:M6,{"=1,2"}),COUNTIFS(AB2:AB6,{"=1,2"},AC2:AC6,{"=1,2"}))

    What am I missing?

    I'd also like to replace the =1,2 with a reference to the cell value (which is 1,2) and simplify this.

    Thank you so much for helping!!
    Matt
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-18-2015
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Golf League Scheduling Analysis

    Can anyone help, please?

+ 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. Golf League Handicaps
    By JRHOG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2014, 01:34 PM
  2. Spreadsheet for my golf League
    By DuncanP in forum Excel General
    Replies: 4
    Last Post: 03-30-2012, 10:39 AM
  3. Golf League Help
    By peterbarone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2005, 12:26 PM
  4. Golf League Schedule
    By Golf League Schedule in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-20-2005, 11:06 AM
  5. [SOLVED] I need a template for weekly scheduling of golf tee times
    By crazforgolf in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-08-2005, 01:06 AM

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