Maxif

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!
 
M

Mike H

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
 
S

ShaneDevenshire

Hi,

You can write a slightly shorter version

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

no need for the FALSE argument.
 
Top