If there is missing data???
 

I have a column of data that automatically updates every half hour. I
looking for a formula that will look at the column and determine if there is
a cell in that was not updated. For example, I have currently have cells
1D:10D that should all be up to date, but cell 7D does not have any data. I
want cell 58D to display "Check". Here's where I run into a problem. I
can't have any VB in this worksheet and the sheet is updating every half hour
with new data (filling in the next time slot). What formula do I use for
this??

Thanks in advance for any insight into this.
--
EW - Analyst

If there is missing data???
 

You dont mention the method used to determine whether the cell "does not
have any data".

Try this:
=IF(ISBLANK(A1), "check", "ok")



--
Rob van Gelder - http://www.vangelder.co.nz/


"ewagz" wrote in message
...
I have a column of data that automatically updates every half hour. I
looking for a formula that will look at the column and determine if there
is
a cell in that was not updated. For example, I have currently have cells
1D:10D that should all be up to date, but cell 7D does not have any data.
I
want cell 58D to display "Check". Here's where I run into a problem. I
can't have any VB in this worksheet and the sheet is updating every half
hour
with new data (filling in the next time slot). What formula do I use for
this??

Thanks in advance for any insight into this.
--
EW - Analyst

If there is missing data???
 

This is where the column runs into problems. The column will contain blanks
after the completed data. The data compiles over a 24 hr time frame and
could contain as little as 1-2 cells in the column of data.I need a formula
that will look at the current array of data and determine whether there
areany blanks.
--
EW - Analyst


"Rob van Gelder" wrote:

You dont mention the method used to determine whether the cell "does not
have any data".

Try this:
=IF(ISBLANK(A1), "check", "ok")



--
Rob van Gelder - http://www.vangelder.co.nz/


"ewagz" wrote in message
...
I have a column of data that automatically updates every half hour. I
looking for a formula that will look at the column and determine if there
is
a cell in that was not updated. For example, I have currently have cells
1D:10D that should all be up to date, but cell 7D does not have any data.
I
want cell 58D to display "Check". Here's where I run into a problem. I
can't have any VB in this worksheet and the sheet is updating every half
hour
with new data (filling in the next time slot). What formula do I use for
this??

Thanks in advance for any insight into this.
--
EW - Analyst

If there is missing data???
 

Try CountBlank:

=IF(COUNTBLANK(A1:A5)0, "check", "ok")

--
Rob van Gelder - http://www.vangelder.co.nz/


"ewagz" wrote in message
...
This is where the column runs into problems. The column will contain
blanks
after the completed data. The data compiles over a 24 hr time frame and
could contain as little as 1-2 cells in the column of data.I need a
formula
that will look at the current array of data and determine whether there
areany blanks.
--
EW - Analyst


"Rob van Gelder" wrote:

You dont mention the method used to determine whether the cell "does not
have any data".

Try this:
=IF(ISBLANK(A1), "check", "ok")



--
Rob van Gelder - http://www.vangelder.co.nz/


"ewagz" wrote in message
...
I have a column of data that automatically updates every half hour. I
looking for a formula that will look at the column and determine if
there
is
a cell in that was not updated. For example, I have currently have
cells
1D:10D that should all be up to date, but cell 7D does not have any
data.
I
want cell 58D to display "Check". Here's where I run into a problem.
I
can't have any VB in this worksheet and the sheet is updating every
half
hour
with new data (filling in the next time slot). What formula do I use
for
this??

Thanks in advance for any insight into this.
--
EW - Analyst