+ Reply to Thread
Results 1 to 2 of 2

Extract based on multiple criteria

  1. #1
    Forum Contributor
    Join Date
    05-28-2010
    Location
    Antwerp, Belgium
    MS-Off Ver
    Office 365
    Posts
    170

    Extract based on multiple criteria

    I would like to extract rows from one table to another table based on MULTIPLE criteria.

    Before going to deep into explanations I will just show you that I managed to do it based on ONE criteria and all I need is to add another criteria:

    {=IFERROR(INDEX(Free[Task],SMALL(IF(Free[Cust]=B$1,ROW(Free[Cust])-ROW(Free!C$2)+1),ROWS(Free!C$2:C2))),"")}

    In this formula I am taking what's in the column named "Free[Task]" and only IF in the column "Free[Cust]" it matches with what's in the cell C2 then it will extract these values. It works great.
    What I need now is to add another IF, that will say IF in column named "Free[V]="V" only then take whats in column named "Free[Task]".

    I am trying to avoid uploading the excel, but if necessary I will. Maybe someone can give me a quick solution without it..

    Thanks!

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Extract based on multiple criteria

    Hi.

    Looks like:

    =IFERROR(INDEX(Free[Task],SMALL(IF(Free[Cust]=B$1,IF(Free[V]="V",ROW(Free[Cust])-ROW(Free!C$2)+1)),ROWS(Free!C$2:C2))),"")

    though I personally wouldn't use an IFERROR set-up if the expected number of returns was quite large.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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] Extract data based on multiple substring criteria
    By jspharriola in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2013, 01:50 AM
  2. extract rows from sheet based on multiple criteria
    By frederikk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2012, 04:12 AM
  3. Extract Data Based on Multiple Criteria
    By trevaaaaaaa in forum Excel General
    Replies: 2
    Last Post: 03-14-2012, 11:42 AM
  4. Replies: 2
    Last Post: 07-19-2011, 04:08 PM
  5. Replies: 2
    Last Post: 03-23-2011, 06:19 PM

Tags for this Thread

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