Max If function

[BK]

Ron,

The below formula works in case column A has text value. If my col A has numerical value , how can i write the formula to find max value in Col B ???


=MAX(INDEX((A2:A10="Dog")*B2:B10+(A2:A10<>"Dog")*MIN(B2:B10),0))


Thanks in advance

BK

 

[ShaneDevenshire]

Hi,

You question isn't clear to me but if you are trying to find the maximum
value in column b which for a given numerical value in column A then
=MAX(IF(A1:A10=1,B1:B10,""))

This should be array entered. Press Shift+Ctrl+Enter