max number depending on column left

[psychic duck]

NFL 51
NBA 67
NFL 43
NHL 35

In this table I want to be able to find the highest number, but only with the text "NFL" to the left of the number.

So it therefore doesn't include 67 which is the highest answer but gives the value 51 which is the highest answer with NFL to the left of it.

I want it in a formula not in filter.

 

[Maudise]

A messy (but workable) way of doing it would be to input a new column and use the formula

=if($A1 = "NFL", "$B1, "") then use MAX(C:C)

 

[Aladin Akyurek]

NFL 51
NBA 67
NFL 43
NHL 35

In this table I want to be able to find the highest number, but only with the text "NFL" to the left of the number.

So it therefore doesn't include 67 which is the highest answer but gives the value 51 which is the highest answer with NFL to the left of it.

I want it in a formula not in filter.

Try...

Control+shift+enter, not just enter:

=MAX(IF($A$2:$A$5="NFL",$B$2:$B$5))

 

[bdub]

--- Edit ---

Sorry already answered - Adadin's solution will work great!

 

[psychic duck]

thanks for the help, I didn't know about entering the data with control shirt enter, but it now works