Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter like data..help please
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pull data - Advance Filter | Excel Worksheet Functions | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Data Filter - Not all rows in spreadsheet will display in Autofilt | Excel Worksheet Functions |