![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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 ![]() Please help me out !! Thanks in advance !! |
Tags |
data matching |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing columns within sheet | shabbaranks | Excel | 2 | 09-11-2012 05:03 AM |
![]() |
shabbaranks | Excel Programming | 4 | 08-21-2012 08:00 AM |
If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
![]() |
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |