test if column isblank
 

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

test if column isblank
 

=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

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

test if column isblank
 

Just be sure to look out for formulae that return "" like

=IF(1=1,"","")
--
Gary's Student


"Spike" wrote:

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