test if column isblank
Thank you i knew it was basic!!
--
with kind regards
Spike
"Bob Phillips" wrote:
=COUNTA(A:A)=0
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Spike" wrote in message
...
Probbably very basic but just cannot think grateful for any help.
How do i test using a built in formula if a column is blank ie it has no
text or numbers in it. I can do it using code etc but would like to use a
formula
--
with kind regards
Spike
|