finding minimum value

G

Guest

I have to find minimum value in a range of column for eg. a1 to a100 other
than zero.
The formula "=min(a1:a100)" returns value 0 if the minimum value is 0 but I
require
the minimum value other than zero (all my values are in positive side only)
 
J

JE McGimpsey

One way (array-entered: CTRL-SHIFT_ENTER or CMD-RETURN):

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

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

Finding a Minimum Number other than Zero within a Range 7
Variable Range Copy... 13
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
Show Minimum value 2
Formula for neg and pos values 4
MINIMUM OF POSITIVE VALUES only 4
Looking for a way to calculate the minimum and maximum value of a formula . 0
Need help with formulas 1

Top