Maxif

  • Thread starter Thread starter AMB
  • Start date Start date
A

AMB

I need to know how to do a functin that would be like a "max if", please. I
have several columns of data. I want to find the max value in column F if
column n matches my criteria. I have several differnt criteria that I need
to find the max for each sub group and do not want to sort in the criteria
order to find the max as i am always adding new data.



Thanks!
 
Try

=MAX(IF(N1:N1000=A1,F1:F1000,0))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
just enter. If you do it correct then Excel will put curly brackets around
the formula{}. You can't type these yourself. If you Edit the ranges
then you must re-enter as An array

Mike
 
Hi,

You can write a slightly shorter version

=MAX(IF(C2:C24=A1,A2:A24))

no need for the FALSE argument.
 
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

MAXIF? 4
MAX value but with two comparison filtering criteria 5
Extracting Matrix Data 3
need to jump cells in column data when finding average, max and mi 1
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Finding criteria within a range 3
Total of 2 columns in pivot table 5
Max() Dmax() Looking for MaxIf() Equiv. 4

Back
Top