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...
Not sure if this is still needed, but I just came across an easy solution that works for my data set.
=MINIFS(Min range, range criteria, "<>0")
This took the 10 columns I was looking at and gave me the lowest value that was not zero.
The range had to be the exact rows that I had to copy down, so for range I had to select, for example I had to write the formula this way. =MINIFS(A1:A10,A1:A10, "<>0") and copy it down my list which worked well for my data set.