Minimum Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers, including zeros. I want to find the minimum
number, but not zero. Is there an Excel calculation?

KEN
 
Here's one way:
=SMALL(A1:A20,COUNTIF(A1:A20,0)+1)
counts the number of zero's and gives you the next smallest number that
isn't zero. This assumes values in column A, thru row 20, adjust as
necessary.
 
One way, assuming no negative numbers:

=LARGE(A:A,COUNTIF(A:A,">0"))
 
If there are no negative numbers:

=SMALL(A1:A20,1+COUNTIF(A1:A20,0))

This one will work with negatives:

Array entered using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):

=MIN(IF(A1:A20<>0,A1:A20))

Biff
 
I kinda figured that was a safe assumption, if MIN was giving him the zero,
but you're right, I should have said so.
 
You must log in or register to reply here.

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

minimum function but want to exclude zero 2
Help with MIN fxn please! 2
return a minimum value of 1, except when multiplied by an empty ce 6
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Minimum non-zero value 3
getting the min and max of a list of numbers 9
Making Zeros look like no entry 5
finding minimum value excluding zero 6

Back
Top