Forum Discussion
I have a question about the MIN formula
I'm trying to find the minimum value in a column of numbers, but if the value is 0 I don't want to consider it. In other words, I'd like to ignore the zeros. I can't seem to find a way to do this wit...
Just for the collection, non-array formula
=AGGREGATE(15,6,(1/A1:A5>0)*A1:A5,1)
if Excel 2010 and later
Still for the collection a non-array solution that works with all versions of Excel:
=SUMPRODUCT(MIN( ((A1:A5=0)*(MAX(A1:A5)+1)) +A1:A5))