apologies to the newsgroup
=small(datarange,2)
will be ok only if there is only one zero
probably I was hasty.
I modified this to
=IF(MIN(A1:A13)=0,SMALL(A1:A13,COUNTIF(A1:A13,"0") +1),MIN(A1:A13))
but I found that others have since given more elegant
solutions.


R.VENKATARAMAN wrote in message
...
if you are sure there are some zero values then use
=small(dataange,2)

if you are not sure then use Dmin. see help


jtribe wrote in message
...
in trying to find a min value, how do i exclude zeros from the list to
be
looked at?