Is it possible to detect if every cell in an entire column is null?
S swatsp0p Sep 22, 2005 #2 If, by NULL, you mean blank (no data, no text, no formulas, no nothing) try this: =COUNTIF(A:A,"") will return 65536 if it is truly all blank. O course, use the letter of the column you want to verify. Is this what you are looking for
If, by NULL, you mean blank (no data, no text, no formulas, no nothing) try this: =COUNTIF(A:A,"") will return 65536 if it is truly all blank. O course, use the letter of the column you want to verify. Is this what you are looking for
D Dave Peterson Sep 22, 2005 #3 if you mean truly empty, one more: =if(counta(c:c)=0,"all cells empty","not all cells empty")
