Is it possible to detect if every cell in an entire column is null?


--
syuhas
------------------------------------------------------------------------
syuhas's Profile: http://www.excelforum.com/member.php...o&userid=27486
View this thread: http://www.excelforum.com/showthread...hreadid=470009

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. Of
course, use the letter of the column you want to verify.

Is this what you are looking for?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=470009

if you mean truly empty, one mo

=if(counta(c:c)=0,"all cells empty","not all cells empty")



syuhas wrote:

Is it possible to detect if every cell in an entire column is null?

--
syuhas
------------------------------------------------------------------------
syuhas's Profile: http://www.excelforum.com/member.php...o&userid=27486
View this thread: http://www.excelforum.com/showthread...hreadid=470009

--

Dave Peterson