Copying date if 'date' matches with the reference

S

Sajjad Qureshi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Date Help W/Avg work days 7
How to getting text labels to show up in scatter chart. 0
Date match problem 2
Help!! find two number recurring numbers in row?? 1
15 minute data to daily data 1
Gears 14
I'm trying to do a "count" function at the end of a dynamic pivot table 0
For Loop 9

Top