MIN excluding 0s

G

Guest

Hi, I need to find the lowest value in a row, excluding zeros.

If I use the formula below as an array, I only get a #N/A returned:
=MIN(IF(H38:J38>0;H38:K38))

How to do it correctly?
 
J

Jerry W. Lewis

The two arrays must be the same size (end in column J or K?) and the
formula must be array entered (Ctrl-Shift-Enter).

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

struggling with if logical test function 2
lowest number in a set EXCLUDING zero 2
Minimum array formula. 5
Evaluating Equations Based on Selection !! 3
Min Function 8
Average of values in row excluding the highest and lowest value? 18
Trying to find additional ranges outside of min, max, and average 2
Help! Minimum Excluding zeros across multiple sheets 5

Top