+ Reply to Thread
Results 1 to 5 of 5

Every data result, multiple criteria

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Seattle
    MS-Off Ver
    Excel 2013
    Posts
    5

    Every data result, multiple criteria

    Hey All,

    I am trying to pull all values from a dataset using multiple conditions. I have narrowed this down to two formulae, but I cannot figure out how to combine the two. The first formula can pull every result of data based on a single condition, while the second formula can only pull the first result of the data based on multiple conditions. I hope I've explained this thoroughly enough. Here is a copy of the formulae and an attached sample workbook.

    Every result, one criteria:
    {=IF(ISERROR(INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$F$2,ROW($A$1:$A$14)),ROW(1:1)),2)),"",INDEX($A$1:$B$14,SMALL(IF($A$1:$A$14=$F$2,ROW($A$1:$A$14)),ROW(1:1)),2))}

    First instance, multiple criteria:
    {=INDEX($B:$B,MATCH(1,($F$2=$A:$A)*(10=$C:$C)*(2011=$D:$D),0))}

    Thank you, this place is a godsend lol.

    sample data.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,625

    Re: Every data result, multiple criteria

    What are the multiple criteria, in this case?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,625

    Re: Every data result, multiple criteria

    Never mind. I see it now!!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,625

    Re: Every data result, multiple criteria

    OK. This should do what you want. Array formula... but you know about htat...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-26-2013
    Location
    Seattle
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Every data result, multiple criteria

    Works perfectly! Thank you!

+ 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. [SOLVED] Search for multiple rows from multiple sheets by criteria & show result in userform
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-07-2014, 11:29 AM
  2. Replies: 4
    Last Post: 03-18-2014, 11:50 AM
  3. [SOLVED] Multiple criteria and lists for one result
    By gyj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2012, 01:46 AM
  4. Multiple Criteria in SumProduct, N/A Result
    By dcd123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2005, 08:26 AM
  5. How do I Provide a specific result given multiple criteria?
    By Luis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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