Glad you got it all working correctly.

And thank you for feeding back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Marie Bayes" wrote in message
...
Thanks for getting back and another apology, another mistake in the
formula,
I'd had it checking row 1 when on row 2 (I forgot about my header row) etc
etc, I've fixed this and now the zero value is showing in the right place,
thanks once again and sorry to have made such a stupid mistake!