+ Reply to Thread
Results 1 to 5 of 5

Searching Multiple Criterias and Returning Multiple Results

Hybrid View

  1. #1
    Registered User
    Join Date
    09-01-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    13

    Searching Multiple Criterias and Returning Multiple Results

    I've done several searches on the subject and though most results are close, none seems to be exactly what I'm looking for. So I figured I would turn to the pros.

    I have a sheet with an athletic scoring system.

    For example: (A1)Team A, (B1)Points For, (C1)Points Against, (D1)Opposing Team

    Since this is a league, these teams play each other several times. Team A may be home one week, visiting the next.

    For example: Team A, 2, 3, Team B and next game Team B, 3, 5, Team A.

    Keep in mind there are several teams and obviously several scoring outcomes.

    What I'm trying to do is find a code that would search the teams I would place in cell F1 and G1, and generate a list right below (F2:F20 & G2:G20) of the games they've played against one another and the scores of those games.

    There are exactly 1230 games played between 30 different teams, if that helps any.

    Any help on this would be greatly appreciated.

    Thanks in advance.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,861

    Re: Searching Multiple Criterias and Returning Multiple Results

    If you really have Excel 2003 (as stated in profile) you probably shall use SUMPRODUCT function. If 2007+ SUMIFS shall help.
    If this tip is not enough for you - have a look on forum rules and find how to attach sample workbook.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-01-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Searching Multiple Criterias and Returning Multiple Results

    Hey Kaper,

    Here's a workbook with an example. How would SUMIFS or SUMPRODUCT work to generate what I'm looking for? I'm no expert, so coding isn't my strong suit.
    Attached Files Attached Files
    Last edited by boaesh; 04-13-2014 at 11:01 AM.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,861

    Re: Searching Multiple Criterias and Returning Multiple Results

    Hi boaesh,

    So now it is easy to see what you are looking for. Assuming EX2003 compatibility (xls extension) I proposed two formula - one array formula (comitted with Ctrl+Shift+Enter) as a helper to find rows with interesting matches the other one normal, just to report results from appropriate row.

    See attachment - formulas in yellow cells copied down (and right if necessary).

    PS. Please read our rules and edit your post to comply with point 12.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-01-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    13

    Re: Searching Multiple Criterias and Returning Multiple Results

    Awesome! You rock my friend!

+ 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. Searching multiple sheets and returning multiple results
    By BuzzT in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-14-2014, 10:11 AM
  2. looking up with multiple criteria and returning multiple results
    By stejp79 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-04-2013, 04:25 AM
  3. [SOLVED] VBA for extracting different results based on multiple criterias
    By siduri in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-29-2012, 10:09 AM
  4. Searching one value and returning multiple values in one cell
    By Ray789 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-27-2008, 04:31 PM
  5. Searching Row and returning multiple values
    By RichardCragg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2007, 07:36 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