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?