Results 1 to 5 of 5

Count Matches, Not Games

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-30-2012
    Location
    Seattle, WA
    MS-Off Ver
    Office 2007
    Posts
    212

    Count Matches, Not Games

    I have a spreadsheet that is used to track stats during a tournament. In the past we have always used a number of games as the minimum before a team's rating can change. We would like to change it so it's a minimum number of matches instead. A match can be as few as 2 games and (currently) as many as 7 games. If you look at the sample spreadsheet I've attached, the match data starts in column J. I've marked the top of the sheet to delineate matches but I'm not sure how the count the number of unique matches. The formula should be (for the first team) in E5. I've filled in that cell for the three examples. Any help would be greatly appreciated.
    Attached Files Attached Files
    "Laugh? I thought I'd die!"

    Jimbo?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 08-07-2017, 01:33 PM
  2. last 6 games form in soccer matches,suitable formula
    By davide2574 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-23-2014, 06:03 AM
  3. [SOLVED] Count number of occurrences but if there are consecutive matches count them as one
    By michaljireht in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-26-2013, 08:26 PM
  4. Count games played
    By geminiviper in forum Excel General
    Replies: 68
    Last Post: 10-20-2011, 11:00 AM
  5. [SOLVED] COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE.
    By witchcat98 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2005, 10:06 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