Have I got a blank cell

  • Thread starter Thread starter Paul Lautman
  • Start date Start date
P

Paul Lautman

=MATCH("R",range1,0) will tell me if any cell in range1 is equal to "R"
=MATCH("",range1,0) will tell me if any cell in range1 contains nothing (for
instance just a single ' )

But how do I tell if any cell in range1 is completely blank?
 
This formula will tell you the relative position of the
first blank cell in "range1" if there is one, if not, it
will show an #N/A error,

=MATCH("EMPTY",IF(range1<>"",range1,"EMPTY"),0)
Is an array formula so commit with CTRL+SHFT+ENTER

You can get RID of the #N/A error by using something like
this, this will display "NO BLANK" instead of #N/A but you
can change for what ever you want...

=IF(ISERROR(MATCH("EMPTY",IF(range1<>"",
range1,"EMPTY"),0)),"NO BLANK",MATCH("EMPTY",IF
(range1<>"",range1,"EMPTY"),0))

Cheers
Juan
 
Back
Top