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.

"Ken" wrote:

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

KEN

One way, assuming no negative numbers:

=LARGE(A:A,COUNTIF(A:A,"0"))

In article ,
Ken wrote:

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

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

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

KEN

FWIW, also assumes only non-negative numbers.

In article ,
BoniM wrote:

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.

I kinda figured that was a safe assumption, if MIN was giving him the zero,
but you're right, I should have said so.

"JE McGimpsey" wrote:

FWIW, also assumes only non-negative numbers.

In article ,
BoniM wrote:

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.