Max

  • Thread starter Thread starter ceemo
  • Start date Start date
C

ceemo

I would like to take the max value of one column where anouther column
meets a criteria
 
here is an example

entered as an array formala (control+shift+enter)

=MAX(IF(E5:E7=1,D5:D7))

max of d5:d7 subject to e5:e7 being 1
 
Try...

=MAX(IF(RangeX=Cond,RangeY))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAX value but with two comparison filtering criteria 5
Maxif 2
Max Length in a row 1
Extracting Matrix Data 3
Max If 1
How pull ID#s that meet specific "yes" requirements 3
crazy format/formula 4
finding the cell adjacent to the max value in a row with formula 4

Back
Top