+ Reply to Thread
Results 1 to 3 of 3

Extract data from one Column if Condition is in 2 Columns

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Extract data from one Column if Condition is in 2 Columns

    Hi,
    I want to extract consecutive Data from B3:B15 if H2 is in C3:D15 (C3:C15 OR D3:D15)
    Thanks for help...
    Attached Files Attached Files
    Last edited by ionelz; 10-19-2020 at 08:19 PM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Extract data from one Column if Condition is in 2 Columns

    Please try at G4
    =IFERROR(INDEX(Table1[Cable],AGGREGATE(15,6,ROW(Table1)/((Table1[Con1]=$H$2)+(Table1[Con2]=$H$2)>0),ROWS(G$4:G4))-ROW(Table1[#Headers])),"")

    or
    =IFERROR(INDEX(Table1[Cable],AGGREGATE(15,6,ROW(Table1)/(MMULT(N(Table1[[Con1]:[Con2]]=$H$2),{1;1})>0),ROWS(G$4:G4))-ROW(Table1[#Headers])),"")
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Extract data from one Column if Condition is in 2 Columns

    Like always, work great, thank yo Bo

+ 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 from Column with one condition and two conditions
    By ionelz in forum Excel General
    Replies: 2
    Last Post: 10-11-2020, 04:23 PM
  2. data extract in column, formula, split into various columns
    By dude6571 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2020, 01:51 PM
  3. [SOLVED] How to extract non-matching data of two columns into another column
    By kolokoy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-13-2016, 11:11 AM
  4. [SOLVED] Extract data from third column where data in two other columns match
    By redimp in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-16-2014, 10:01 AM
  5. Populate 2-column data to multiple columns based on one condition
    By hcyeap in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-26-2013, 10:42 AM
  6. Replies: 7
    Last Post: 09-15-2013, 12:09 PM
  7. [SOLVED] Extract data from column to make new columns
    By cinco5 in forum Excel General
    Replies: 2
    Last Post: 10-10-2012, 04:18 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