I hope someone can help me on this. I have two sets of data as follows:
Data Set 1:
Name Date Hours
A 10/20/2019 2
A 10/21/2019 3
A 10/22/2019 4
A 10/23/2019 2
B 10/20/2019 1
B 10/21/2019 2
B 10/22/2019 7
C 10/20/2019 2
C 10/21/2019 4
C 10/24/2019 8
C 10/25/2019 6
C 10/27/2019 5
D 10/23/2019 4
D 10/24/2019 1
D 10/25/2019 8
D 10/26/2019 2
Data Set 2
Name Date Hours
A 10/22/2019 4
B 10/21/2019 2
C 10/25/2019 6
D 10/24/2019 1
So the requirement is that we want to extract all the data from Data Set 1 from the dates mentioned in Data Set 2 for each Name. For example, in the data set 1, there are 4 records for the Name A, so after the extraction, the output should be:
Name Date Hours
A 10/22/2019 4
A 10/23/2019 2
and same for the other Names in the Data Set 1:
B 10/21/2019 2
B 10/22/2019 7
C 10/25/2019 6
D 10/24/2019 1
D 10/25/2019 8
D 10/26/2019 2
I appreciate your help hereThanks in advance.
Edit: I have attached Excel file with the data in it for your convenience.
Bookmarks