Forum Discussion
MIN function exclude "Zero" values - Non Consecutive group of cells
I am struggling with ignore zero values when the group of cells to be tested is not a consecutive range The function "=MIN(D7,M7,V7,AE7,AN7)" works fine but I want to ignore lowest value if AE7 a...
Interesting!
Just replacing MIN by SMALL to meet Tom's requirement of retrieveing the second smallest number and beautiful alternative.
With IF() we return FALSE if the value is zero, and logical value is ignored by MIN()