View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spike
 
Posts: n/a
Default 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