Min/Max of an array

=max(if($l$14:$l$194=f5,$j$14:$j$194))

You are trying to find the maximum of a range of negative numbers and 0. So 0 will always be bigger than the negative numbers. Instead of 0 in the IF statement, use an obscenely big negative number, for example

=MAX(IF($L$14:$L$194=F5,$J$14:$J$194,-99^99))

or drop the FALSE argument altogether, because it is not needed.

=MAX(IF($L$14:$L$194=F5,$J$14:$J$194))

Hi

Try

=MAX(IF($L$14:$L$194=F5,J$14:$J$194))

Try this regular formula...

=MAX(INDEX(($L$14:$L$194<>F5)*-10^99+$J$14:$J$194,0))

Does that help?

Really, nice one, Ron.