Assuming that you don't have any negative values

=$D4=SMALL($D$4:$D$15,COUNTIF($D$4:$D$15,0)+1)


--


Regards,


Peo Sjoblom



"Jock" wrote in message
...
Hi,
How do I get this:
=COUNTIF($D4,(MIN($D$4:$D$15)))
to ignore zero's?

--
Traa Dy Liooar

Jock