|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 !! |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Quote:
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 Last edited by Zubairkhan; 03-05-2014 at 12:41 AM. |
Tags |
data matching |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removing columns within sheet | shabbaranks | Excel | 2 | 09-11-2012 05:03 AM |
Exporting workbook specific sheet columns on exit | 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 |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |