LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
connect line to data points with missing data in between ziak Charts and Charting in Excel 4 April 4th 23 10:35 AM
Missing Cloumn data when importing external data Findus Excel Discussion (Misc queries) 0 December 16th 08 11:22 AM
How to determine the cause of missing data after I importing data LMonro Excel Discussion (Misc queries) 7 October 26th 07 04:00 AM
How do i plot a data set that has one data point missing planet SA Excel Discussion (Misc queries) 1 September 9th 07 07:50 PM
Import External Data is missing some data Mark D. Brown, MSW Excel Discussion (Misc queries) 0 January 5th 06 06:43 PM


All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"