Determine if row is blank

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

I have a worksheet that gathers information from multiple
other worksheets. I would like to be able to determine
if every cell in a row (or a range) is null. Is there an
easy way to do that?

thanks
 
Hello Joseph,

You count use the COUNTA function. For example:
=COUNTA(D:D)
would return a count of the rows in Column D that have any data in them,
including nulls.

Cheers
 
=if(counta(1:1)=0,"all empty","something in it")

or
=if(counta(a1:b99)=0,"empty","not empty")
 
Thanks for the suggestion. I tried it, but counta counts
my cells with functions as non-blank even if the result
of the equation is blank. But excel showed me the
function countblank() as a cousin to counta and that
works.

thanks.
 
Do you mean something like this??

= LEN(A1); fill down.
this will return 0 if cell is blank

or

ISBLANK(A1) equals TRUE if blank
 
Back
Top