MaxIf with associated row info?

Im using array formulas to determine the maximum value of a specific subset of row data:


This works fine & gets me the maximum value in C where A = “somestring”.

  • VBA Excel : Choose the hour and the minute from a list
  • java.lang.ClassNotFoundException:
  • Excel VBA Open File (error handling)
  • Apache POI Put an excel cell in bold
  • Download Data from HTML table to excel
  • Formula to remove entire words that start with certain characters
  • Now, I want to return other column values associated with this “max” row that are strings. Intuitively I think I may need to ditch the boolean logic multiplication strategy since string values are getting involved. What’s the best/cleanest way to go about this?

  • Categorizing bank transactions in Excel
  • Unable to Insert FormulaArray in Cell in VBA
  • Excel array formula INDEX()
  • Doing an array formula lookup
  • excel calculation on 2 tables - one with data, the other with references
  • Excel - (Array Formula) Sum IF Multiple Criteria with a Difference
  • 2 Solutions collect form web for “MaxIf with associated row info?”

    Try this:


    Column you want values for is set to B in this example.

    Assuming you’re interested in the string in column D, this will work:


    Note that since it’s Indexing on the Row() you’re Index column needs to start at 1, e.g., D1:D100.

    MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.