Hi everyone,
I have two worksheets, the first is a set of date/times and values like
this:
DATE_TIME VALUE
2006-01-01 0:15 5.798
2006-01-01 0:30 5.804
and the other worksheet is and 'Override" table where the tech inputs a
value for the entire day that nullifies the data from the first table.
Like this
OR_DATE VALUE
2006-01-01 -999.999
I need to have a column in the first worksheet where if any if the
values from worksheet#1 and included in the date from Worksheet #2,
the -999.999 value is show.
It doesn't have to overwrite the worksheet#1 data, just have the
-999.999 show up in a column beside it.
I bet it is easy but I am sure stuggling with it as the date values
don't exactly match up. Any help would be GREATLY appreciated.
Derek
--
DerekF
------------------------------------------------------------------------
DerekF's Profile:
http://www.excelforum.com/member.php...o&userid=34882
View this thread:
http://www.excelforum.com/showthread...hreadid=546272