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.