Max if statement to return blank if no data

[Parkerpen13]

Here is my current formula {max(if(a3:a1000=B3,i3:i1000,””))}. So this is returning my max value when there is one or multiple but it’s putting a 0 when there isn’t anything.

 

[Marcílio_Lobão]

Parkerpen13, Good morning.

Until a more elegant formula arrives I believe that can be used:

ARRAY FORMULA:

=IF(MAX(IF(A3:A1000=B3,I3:I1000))=0,"",MAX(IF(A3:A1000=B3,I3:I1000)))

Is that what you want?
I hope it helps.

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=if(countifs(a3:a1000,b3),max(if(a3:a1000=b3,i3:i1000)),"")

 

[Parkerpen13]

Awsome thanks for the help I was beating my head against the table in that one. Thanks a ton