Minimum 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
|