Return Maximum value with Conditions

Hi Azam Ali (no mistakes from you),

as far as MIN(IF... or MAX(IF... are concerned you can use these array formulae only relating to ranges of numbers. Relating your example, you should adjust the formulae using ISNUMBER.

In other words, the formulae exclude zeros playing only with numbers and don't accept non numeric strings.

Excuse my English if it's not clear.

Regards

Edit: Sorry Haseeb A, I did not mean to overlap.
नमस्ते