+ Reply to Thread
Results 1 to 5 of 5

Extract row for specific cells with Criteria's

  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    591

    Extract row for specific cells with Criteria's

    Hello Friends

    In the Column B for the `ABC dmkijtfsh' and if the word `Faco' is not there then need to extract the row for specific cells (Column H, K, AA & AT)

    In attached excel refer the required result in Sheet 2 Light yellow cells, Sheet 3 shows the after filtered view for better understanding.

    thanks in advance

    Sekar
    Sekar

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,193

    Re: Extract row for specific cells with Criteria's

    I've looked at your workbook. Is it the filtered list you are trying to produce? Are you still using Excel 2010?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    591

    Re: Extract row for specific cells with Criteria's

    Yes, filtered rows (as shown in Sheet 3) with selected columns cells need to be plot by formula. Still using MS Excel 2010.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    30,859

    Re: Extract row for specific cells with Criteria's

    And so, back to the question...

    In A2, copied across and down:

    =IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$B$4:$B$87)/((Sheet1!$B$4:$B$87="ABC dmkijtfsh")*ISERROR(SEARCH("Fako",Sheet1!$H$4:$H$87))),ROWS($1:1))),"")
    Glenn



  5. #5
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    591

    Re: Extract row for specific cells with Criteria's

    Hello Glenn

    Thank you

    Amazing, I except i need array formula, but this is done without array formula,

    This will save my lot of work.

    Thanks again

    Sekar

+ 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 of data based on specific criteria
    By Mansfieldexcel in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-04-2019, 08:50 AM
  2. [SOLVED] Extract values from a database based on a specific criteria
    By Charli53 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2017, 03:35 AM
  3. Replies: 1
    Last Post: 06-18-2017, 08:57 AM
  4. [SOLVED] Need ideas to extract information with specific criteria
    By ovgarcia24 in forum Excel General
    Replies: 1
    Last Post: 04-10-2016, 09:56 PM
  5. Using formulas to extract data meeting 2 specific criteria
    By Levie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-01-2012, 09:27 PM
  6. Macro to extract data from multiple workbooks, specific sheet, specific cells
    By crissandraauree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2012, 03:54 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