Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
connect line to data points with missing data in between | Charts and Charting in Excel | |||
Missing Cloumn data when importing external data | Excel Discussion (Misc queries) | |||
How to determine the cause of missing data after I importing data | Excel Discussion (Misc queries) | |||
How do i plot a data set that has one data point missing | Excel Discussion (Misc queries) | |||
Import External Data is missing some data | Excel Discussion (Misc queries) |