| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| test for date in column question | Excel Worksheet Functions | |||
Hybrid Mode
