+ Reply to Thread
Results 1 to 2 of 2

ignore direct text matches but sum related opponents ( Title=WIP)

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2011 Mac
    Posts
    50

    ignore direct text matches but sum related opponents ( Title=WIP)

    First off, did not know how to label the thread title, I will take recommendations. But here is what I am trying to figure out (I have attached a test worksheet with the answers i need).

    In A2:A7, I have matchups between 2 teams. It shows who beat who.
    In columns C, E & G, it shows which team is being tracked.
    In columns B, A & F, it shows which teams columns C, E & G have played against.

    Starting with cell C2, I am tracking Team A and, according to A2:A7, Team A has only played Team B, but they played each other twice. 2 is the result in cell C2 because Team B has played only 1 other game against another opponent (cell A3 - 'B beats C'). That 1 game would yield a result of 1 but since Team A played Team B twice, 2x1=2. These same rules apply for E2:E3 & G2:G3.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-10-2013
    Location
    Columbus, OH
    MS-Off Ver
    Excel 2011 Mac
    Posts
    50

    Re: ignore direct text matches but sum related opponents ( Title=WIP)

    If this cannot be done I could settle for the correct way to write this formula.

    =COUNTIF(A2:A7,(B2&" beats "&<>C2))

+ 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: 2
    Last Post: 09-19-2013, 09:06 AM
  2. Return Range of Cells whose title matches given cell
    By Whimsical in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2013, 03:29 AM
  3. Replies: 6
    Last Post: 11-22-2012, 09:56 AM
  4. Replies: 4
    Last Post: 07-18-2012, 02:34 PM
  5. [SOLVED] Calculate Opponents Win Loss Record
    By TGCRequiem in forum Excel General
    Replies: 8
    Last Post: 06-25-2012, 05:43 PM

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