calculate maximum of a range and ignore if it is 0.

[tanvi_kalra]

How to calculate maximum of a range and ignore if it is 0. like if max(A1:A6) = 0 and -6 is the second maximum number i want maximum number that is not equal to zero. implement the same logic through excel formulas.

[Punnam]

TRY MAXif

=max(if((A1:A6<>0,A1:a6))

Ctrl+Shift+Enter
To make it array function
Punnam

[Bhuvi]

another alternative,

Please Login or Register  to view this content.

[canapone]

Hi,

if you're using Excel 2010 a possible way could be:

Please Login or Register  to view this content.

Regards