Results 1 to 9 of 9

Find the row of the maximum value based on one condition

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-21-2009
    Location
    England
    MS-Off Ver
    Excel 2016
    Posts
    710

    Find the row of the maximum value based on one condition

    Hi everyone, I posted a similar conundrum a few days back which was kindly solved, I can't work out how to replicate the formula for what I need here so am looking for some help.


    I have an attached an example file. What I am trying to do is find the row number with the highest value in column C where the value in column A is 1

    The formula I have used is

    =MATCH((MAXIFS(C:C,A:A,1)),C:C,0)
    but it is giving row number 95 - this can be seen in cell I3 where the formula is stored. It should be returning row 143, which I have manually typed into cell I4.

    Can someone help with this formula?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find the row of the minimum value based on one condition
    By cmb80 in forum Excel General
    Replies: 8
    Last Post: 08-09-2022, 06:20 AM
  2. [SOLVED] Find maximum based on right 4 digits
    By Barieq in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2021, 04:49 AM
  3. [SOLVED] Find specified value's possible combination in a row based on condition
    By haxor in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-24-2020, 03:30 AM
  4. [SOLVED] Find text based on condition
    By ganeshkumar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-24-2016, 12:00 PM
  5. [SOLVED] Maximum and Minimum value based on certain condition
    By MAHMUZ in forum Excel General
    Replies: 3
    Last Post: 10-31-2015, 09:51 AM
  6. [SOLVED] Find Highest Value Based on Condition
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2015, 11:05 AM
  7. Maximum & Minimum Dates based on Condition
    By figs in forum Excel General
    Replies: 3
    Last Post: 08-20-2008, 09:43 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