Thread: [Solved] From an XL sheet ,how to keep the group of columns which match with other XL sheet
View Single Post
 
Old 03-04-2014, 04:18 AM
Zubairkhan Zubairkhan is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Mar 2014
Posts: 2
Zubairkhan is on a distinguished road
Cool From an XL sheet ,how to keep the group of columns which match with other XL sheet
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 !!
Reply With Quote