=IF(SMALL(A1:D25,1)=0,SMALL(A1:D25,2),SMALL(A1:D25 ,1))

--
Gary's Student
gsnu200707


"Divy" wrote:

Hi all,

this is what i'm exactly looking for that in a selected range of
cells, i'm looking for the minimum value and it needs to be greater
than zero. whn i give =Min(A1:D25), it gives 0, and i am looking for 3
which is the smallest after 0...

regards,
Divy