Hi everyone,

 

I've got two data sets as below. My question now is: how can I use Dataset2
as a filter for Dataset1? My goal is just to keep the rows of Dataset1 where
the first column (Date) matches the Dates in Dataset2.

 

I would appreciate any solutions to this issue.

 

Many thanks!

S.B.

 

Dataset1:     

                Date      A               B             C             D

1             1977      10           11           12           13

2             1978      14           15           16           17

3             1979      18           19           20           21

4             1980      22           23           24           25

5             1981      26           27           28           29

 

Dateset2:

 

                Date 

1             1977

2             1978

3             1979

 


	[[alternative HTML version deleted]]

