finding minimum value

E

ezil

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

VBA Coding Help for Beginner 0
HLOOKUP, LOOKUP & MATCH doesn't work. Seems not right. 1
Newbie Help - IF Yes No Function 0
Transfer data between two tables 3
Finding a Minimum Number other than Zero within a Range 7
Need to get minimum difference 1
Finding the minimum value in a list but excluding zeros - a variationon an old problem 10
Calculate the median value before a specified list 0

Top