+ Reply to Thread
Results 1 to 6 of 6

Multiple Condition Index match to find max row value

  1. 05-26-2016, 11:29 AM #1
    Sc0tt1e
    Sc0tt1e is offline
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    640

    Multiple Condition Index match to find max row value

    I have a formula I just cannot seem to convieve and have had no joy getting guidance from the interweb so I come to you wondertful people cup in hand once again.

    I have an audit list of work which I would like to check certain cases against the list and find the earliest occurance of the most recent set of TRUE in clumn B based upon the Id number in column A?

    Please Login or Register  to view this content.
    I have provided a book for an example and highlighted the row I would like the return value to be found within.

    First one to solve it earns some reputation
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-26-2016, 11:43 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Multiple Condition Index match to find max row value

    If I understand you correctly, try this regulat formu;a...
    =INDEX(D2:D12,MATCH(A2&TRUE&G2,INDEX($A$2:$A$12&$B$2:$B$12&$C$2:$C$12,0),0))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 05-26-2016, 11:49 AM #3
    Sc0tt1e
    Sc0tt1e is offline
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    640

    Re: Multiple Condition Index match to find max row value

    You appear to be including the result in the formula?

    Columns A-D are the data set, G2 is the result I would like from C11.

    You appear to be returning the right row just from column D instead of Column C. If I can back engineer the formula I can apply it to Column C
    Reply With QuoteRegister To Reply
  4. 05-26-2016, 11:59 AM #4
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,779

    Re: Multiple Condition Index match to find max row value

    Just change D2:D12 to C2:C12 in G2
    Reply With QuoteRegister To Reply
  5. 05-26-2016, 12:02 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Multiple Condition Index match to find max row value

    Quote Originally Posted by Sc0tt1e View Post
    You appear to be including the result in the formula?

    Columns A-D are the data set, G2 is the result I would like from C11.

    You appear to be returning the right row just from column D instead of Column C. If I can back engineer the formula I can apply it to Column C
    So how do you ID which item in C you need to check on?
    Reply With QuoteRegister To Reply
  6. 05-26-2016, 12:50 PM #6
    Czeslaw
    Czeslaw is offline
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,412

    Re: Multiple Condition Index match to find max row value

    I propose to use the AGGREGATE function.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find value from multiple rows and put in in column vlookup or index match
    By Raehan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2016, 02:56 PM
  2. [SOLVED] Index Match with multiple criteria involving find text
    By 3345james in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-30-2015, 11:56 AM
  3. Using index match to find terms on multiple tables?
    By tsiguy96 in forum Excel General
    Replies: 3
    Last Post: 08-12-2015, 05:25 AM
  4. [SOLVED] Index & Match for multiple Column and Row to find header...
    By mr-c in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-31-2014, 08:24 AM
  5. [SOLVED] Index and Match multiple columns and find answer for 3rd in Excel
    By jmcconville18 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 06-09-2014, 09:49 AM
  6. Index/Match formula to find multiple data
    By fastballfreddy in forum Excel General
    Replies: 2
    Last Post: 02-05-2010, 10:25 PM
  7. Use a lookup/index-match with multiple criteria to find a value
    By jdeumer in forum Excel General
    Replies: 3
    Last Post: 07-11-2009, 02:58 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1