View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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