Finding blank cells with a formula.

[George Wilson]

I am assisting a customer in finding blank cells with a
formula. I know he needs to include a NULL or ISNULL type
criteria in his search string but cannot think what it may
be. My customer is using a function similar to:
=IF((AND(OR
("result"=Counters,"result*"=Counters," "=Counters))))
Where he is intending the " "=Counters to count blank
cells. I know this is not right, what is the proper syntax?
TIA
George

 

[Peo Sjoblom]

=A1=""

Or

=COUNTBLANK(A1)=1

Or

=COUNTBLANK(A1:A100)

will give you the number of blank cells

If you need to find them use autofilter or F5>special>blanks