Identify Blank Rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'd like to have a formula that identifies blank rows in
excel (actually not the entire row, but the entire row
except for the first few columns).

I would have thought this would be easy but can't figure
it out. The problem is the limitations of the isblank and
concatenate formulas -- there's a cell limit to each.

Please let me know your ideas. One other restriction -- I
can not use arrays to identify the blank rows.
Thank you,
Craig
 
Craig,

Something along the lines of this:

=IF(COUNTA(D1:IV1)=0,"Blank","Not Blank")

which ignores columns A to C, for row 1.

This will work if your cells are truly blank: i.e., not filled with formulas
that may return "".

If you have formulas like that, then change to

=IF(COUNTBLANK(D1:IV1)=253,"Blank","Not Blank")

HTH,
Bernie
MS Excel MVP
 
Back
Top