+ Reply to Thread
Results 1 to 5 of 5

extract data from list on the basis of multiple criteria

  1. #1
    Forum Contributor
    Join Date
    12-03-2014
    Location
    Mumbai
    MS-Off Ver
    2013 (still learning...)
    Posts
    236

    Lightbulb extract data from list on the basis of multiple criteria

    Hi,
    Pls find an attachment of file which contains list & required result

    actually the list is ongoing increasing, so I want to fetch the records from total list on multiple criteria, I don't want to create table for the list.
    Sr is unique value

    As well as please specify how i can get marks too of same record
    thanks in advance..
    Attached Files Attached Files
    Last edited by sanjuss2; 11-23-2018 at 06:39 AM.

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

    Re: extract data from list on the basis of multiple criteria

    Please try at G4 copy to H4 and copy down

    =IFERROR(INDEX(A:B,AGGREGATE(15,6,ROW(A$4:A$99)/($B$4:$B$99=$H$2)/($C$4:$C$99>=$I$2)/($C$4:$C$99<=$J$2),ROWS(G$4:G4)),COLUMNS($G4:G4)),"")

  3. #3
    Forum Contributor
    Join Date
    12-03-2014
    Location
    Mumbai
    MS-Off Ver
    2013 (still learning...)
    Posts
    236

    Re: extract data from list on the basis of multiple criteria

    It's a wonderful
    but I am sorry that actually the Sr is after marks column i.e. in 3rd column & in sample file I have put it in 1st column...
    Please see the file again & waiting for your reply
    Attached Files Attached Files

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,855

    Re: extract data from list on the basis of multiple criteria

    Please try at F4 and copy down

    =IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(C$4:C$99)/($A$4:$A$99=$G$2)/($B$4:$B$99>=$H$2)/($B$4:$B$99<=$I$2),ROWS(F$4:F4)),COLUMNS($F4:F4)),"")

    or F4:G4 and copy down
    =IFERROR(INDEX($B:$C,AGGREGATE(15,6,ROW(C$4:C$99)/($A$4:$A$99=$G$2)/($B$4:$B$99>=$H$2)/($B$4:$B$99<=$I$2),ROWS(F$4:F4)),3-COLUMNS($F4:F4)),"")

  5. #5
    Forum Contributor
    Join Date
    12-03-2014
    Location
    Mumbai
    MS-Off Ver
    2013 (still learning...)
    Posts
    236

    Re: extract data from list on the basis of multiple criteria

    Both formulas working fine ....

    Thank you so much... it's nice

+ 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. Extract Unique List Based on multiple criteria
    By Herbiec09 in forum Excel General
    Replies: 7
    Last Post: 01-14-2017, 07:23 AM
  2. Extract List Based on multiple criteria
    By Herbiec09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-14-2017, 04:21 AM
  3. [SOLVED] Extract unique list from table that complies to multiple criteria
    By Henk Stander in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-17-2016, 05:41 AM
  4. VBA code to extract text on criteria basis
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2015, 06:37 AM
  5. VBA code to extract text on criteria basis
    By winmaxservices1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2015, 05:09 AM
  6. Extract a list of numbers under multiple criteria to another workbook
    By lks0912 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2013, 08:03 AM
  7. Extract multiple records matching criteria from list
    By William DeLeo in forum Excel Formulas & Functions
    Replies: 56
    Last Post: 09-06-2005, 12: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