do you want truely blank cells or also cells with ""?
isblank counts "" as not blank.
if you want cells with "" results to be counted as blank I would use
=IF(countblank(INDIRECT(ADDRESS(ROW(),1)))=1,0,1) or

=IF(countblank(A9)=1,ADDRESS(ROW(),1)&" b",ADDRESS(ROW(),1))




"Grant Reid" wrote:

Hi

Many thanks to those who responded (JF and Andy) with elegant solutions to
my problem.

Kind Regards - Grant