Forum Discussion
Mohammed A Elrify
Sep 28, 2016Brass Contributor
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...
Mehdi HAMMADI
Nov 09, 2016Brass Contributor
I generaly use a array formula for that like this one
=MIN(IF(A2:A10>0;A2:A10))