How to check for blank cells with formula
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Bob Flanagan" wrote in message
...
Many thanks! I was not aware of that function.
Bob
"T. Valko" wrote in message
...
Try something like this:
=COUNTBLANK(E1:R1)=14
Will return TRUE when all cells are blank/empty.
--
Biff
Microsoft Excel MVP
"Bob Flanagan" wrote in message
...
I have a number of cells in a row that have formulas that return either
text or "". For example:
=IF(FIND(H$1,$A3)0,H$1,"")
will return the text in H1 if cell A3 contains H1. The above formulas
are in columns E through R for each row of data. Some return text, and
some return "". I want to identify which rows return "" for all cells
in that row in column E through R by putting a formula in column S.
Trouble is, I can't figureout the formula!!! I tried CountA, but it
counts cells with "" as a cell with an entry. Any suggestions?
Bob
|