K
Ken
I have a column of numbers, including zeros. I want to find the minimum
number, but not zero. Is there an Excel calculation?
KEN
number, but not zero. Is there an Excel calculation?
KEN
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BoniM
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.
=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.
J
JE McGimpsey
One way, assuming no negative numbers:
=LARGE(A:A,COUNTIF(A:A,">0"))
=LARGE(A:A,COUNTIF(A:A,">0"))
T
T. Valko
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
=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
J
JE McGimpsey
FWIW, also assumes only non-negative numbers.
B
BoniM
I kinda figured that was a safe assumption, if MIN was giving him the zero,
but you're right, I should have said so.
but you're right, I should have said so.