Find the smallest value other than zero
Sometimes my question is the search for the smallest value, except for zero
The function min or small
But fail to it because it will come in short, a smallest value of zero
And we are forced to do the work of an array formula, such as in the
{min(if(A2:A10<>0)*(A2:A10<>""),A2:A10,"")}
And the following suggestion
Argument optional functions
max min av
small large
To neglected zero.
It will be a very, very useful
Greetings to you
1 comment
-
Kenneth Barber commented
MINIFS is a new function in Excel 2016, so you don't have to use any arrays. Also, I don't see why excluding 0 would be so important. Any negative numbers that you might have would make the "not 0" condition useless. Do you mind elaborating?