If you have a range of data filled with numbers where you want to apply 'MIN' function but want to exclude 0. This blog is for you.
Generally in excel if you use 'MIN' function on any given range which consists of 0, the result will be 0 itself.
The below image is showing 2 formulas to use in such cases.
Function One: '=MIN(IF($W$3:$Y$8<>0,$W$3:$Y$8)'. In this formula, there are 2 functions implemented. First, we give an 'IF' condition that the range should be not 0 using '<>' sign, and on the remaining range 'MIN' is applied.
Function Two: '=SMALL(W3:Y8,COUNTIF(W3:Y8,0)+1)'. In this formula, 'SMALL' brings the nth number of smallest value in the given range and 'COUNTIF' helps in fetching that nth value.
Click to know more about:
Hope you'll find the article helpful.
Commentaires