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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Unique Occurences 4
count duplicate (or, inversely, unique) entries, but based on a condition 3
Count unique records in list 4
Finding unique values with Criterias 1
Count Unique Strings 4
Number vs Text 5
nested if statements using "AND" as well as "OR" 2
First row in Selection range (first index of a cell) EXCEL VBA 1

Back
Top