Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-04-2014, 04:18 AM
Zubairkhan Zubairkhan is offline From an XL sheet ,how to keep the group of columns which match with other XL sheet Windows 7 32bit From an XL sheet ,how to keep the group of columns which match with other XL sheet Office 2007
Novice
From an XL sheet ,how to keep the group of columns which match with other XL sheet
 
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
 

Tags
data matching

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing columns within sheet shabbaranks Excel 2 09-11-2012 05:03 AM
From an XL sheet ,how to keep the group of columns which match with other XL sheet 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
From an XL sheet ,how to keep the group of columns which match with other XL sheet Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft