can I use MIN function to find lowest, NON-ZERO or blank value?

G

Guest

I am trying to analyze a large block of data where not all columns have an
entry. I want to find the lowest value (but greater than zero or a blank
cell) and write it into a separate column.
 
B

Bob Phillips

=MIN(IF(A1:A10>0,A1:A10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
B

Biff

Hi!

Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(A1:C5>0,A1:C5))

Biff
 
G

Guest

You guys rock! The formula works perfectly and will save me hours of manual
searching (and worry that I did it right). The worksheet is already at
column AO and growing wider. Thanks for your quick response.
 

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

NumberFormat for small non-zero numbers? 2
How do I find the minimum value greater than zero 1
Trying to find additional ranges outside of min, max, and average 2
lowest number in a set EXCLUDING zero 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Trying to subtract the two lowest values from a row of numbers 4
LOWEST Non-Zero Numbers 2
How to sum the last 5 non-blank cells in a row? 4

Top