Find Minimum Value In A Range Excluding Zero Value In Excel?

How To Find Minimum Value In A Range Excluding Zero Value In Excel?

The following will help to understand the steps on how to find minimum value in a range excluding zero value in excel.

If you are in a rush and want your problem answered, email to exploresarcs@gmail.com or live chat with us.

Let’s say, the data is available from A1 to C10 with few zeros located. The following formula gets the minimum value excluding the zeros.

=SMALL(A1:E7,COUNTIF($A$1:$C$10,0)+1)

www.extendoffice.com/documents/excel/4033-excel-exclude-zero-from-min.html

About the author: admin

You must be logged in to post a comment.