That's got it exactly. Although the zeros are displayed, they're ignored.
Thank you
--
Traa Dy Liooar

Jock


"Peo Sjoblom" wrote:

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