That won't exclude zeroes. You can use SMALL but will still need to use
something like Biff's example, eg

=SMALL(IF(Rng<0,Rng),1) array entered.

or

=SMALL(IF(Rng,Rng),1) array entered.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"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?