| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying date if 'date' matches with the reference
I have data in different tables. When I collate the two, the two sets
of data doesn't match line by line using the date columns as a reference. How can I remove non matching rows from the 2nd data set? Here is how the table looks like. 2/13/1979 2/13/1979 22.894 1.01044 2/14/1979 2/14/1979 22.894 1.01044 2/15/1979 2/15/1979 22.894 1.01044 2/16/1979 2/16/1979 23.064 1.01044 2/20/1979 2/19/1979 23.064 1.01009 'need to remove this 2/21/1979 2/20/1979 23.064 1.01009 2/22/1979 2/21/1979 23.064 1.01009 2/23/1979 2/22/1979 23.064 1.01009 2/26/1979 2/23/1979 23.221 1.01009 2/27/1979 2/26/1979 23.221 1.01033 .................... Thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If date matches and formula hasn't already been calculated previou | Excel Worksheet Functions | |||
| Copying Date and pasting special - DATE CHANGES?!? | Excel Worksheet Functions | |||
| Test cells for values if date matches | Excel Discussion (Misc queries) | |||
| copy row if date matches | Excel Programming | |||
| Using Countif for Date Matches | Excel Worksheet Functions | |||
Linear Mode
