Hello everyone!!

From an Excel sheet ,how to keep only the group of columns which match with similar data from other Excel sheet:

For example,

The data in excel sheet 1 is

DAY HOUR MINUTE VARIABLE_1_VALUE
1 6 24 25
2 8 36 18
3 12 40 76

and so on.......

The data in excel sheet 2 is having much more details than compared to excel sheet 1 but for a different variable value having similar time stamp, say:



DAY HOUR MINUTE VARIABLE_2_VALUE
1 6 24 42
1 8 40 14
1 12 32 8
2 8 36 18
2 8 46 90
3 12 40 69
3 16 50 5

I want to select only those rows from excel sheet 2 which have common time stamp as that of excel sheet 1 which have on them .

Please help me out !!

Thanks in advance !!

Hi and welcome could you please post a XL sheet showing what you have and what you want? Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi... !!

Thank you very much for the quick response. I have attached the snapshots of the excel sheets 1,2,3 (from left to right). I need to choose certain values from the excel sheet 1("input") based on the common data (Day, hour, minute) from excel sheet 2 ("reference") , which must be extracted in order to generate result as shown in excel sheet 3. ("output")

Regards

Zubair

Attached Images

	input.PNG (7.7 KB, 10 views)
	reference.PNG (4.9 KB, 11 views)
	output.PNG (5.0 KB, 11 views)