If there is missing data???

[ewagz]

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

[Rob van Gelder]

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" <[email protected]> wrote in message
news:[email protected]...
>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

[ewagz]

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>

[Rob van Gelder]

Try CountBlank:

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

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


"ewagz" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>>
>>
>>