ExcelBanter - Max If function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Max If function (https://www.excelbanter.com/excel-worksheet-functions/206561-max-if-function.html)

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")*M IN(B2:B10),0))

Thanks in advance

BK

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
--
Thanks,
Shane Devenshire

"BK" wrote:

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")*M IN(B2:B10),0))

Thanks in advance

BK