Results 1 to 4 of 4

Return Multiple Values with Multiple Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    13

    Return Multiple Values with Multiple Criteria

    I'm using Excel 2007/2010.

    I need to know if there is a formula or series of formulas that can be used to return multiple values based on multiple criteria.

    Our company has internal competitions where one department can challenge another department. Just something fun management came up with to motivate everyone to come up with ideas and focused on their work.

    Attached is a sample file to illustrate what I need.

    Sheet 1 is the tracker.
    Col A: the month and year
    Col B: Team 1
    Col C: Team 2
    Col D: Team 1 Representative
    Col E: Team 2 Representative

    Sheet 2 is the match by match results page.

    Most months, each department usually only issues out one challenge. But occasionally, one department may issue two or more challenges. Since each employee can be the representative only once per month, another employee becomes the rep for his/her department.

    In this sample, Team Alpha and Team Bravo challenged each other twice in May 2013.

    The current array I have on the Results sheet seems to be only good if only one challenge is issued per team. It doesn't seem to be able to return multiple values with the multiple criteria.

    Thank you in advance for the assistance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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