Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 03-04-2014, 12:47 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline From an XL sheet ,how to keep the group of columns which match with other XL sheet Windows 7 64bit From an XL sheet ,how to keep the group of columns which match with other XL sheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,524
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
  #3  
Old 03-04-2014, 10:57 PM
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
Default

Quote:
Originally Posted by Pecoflyer View Post
Hi and welcome could you please post a XL sheet showing what you have and what you want? Thx

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
File Type: png input.PNG (7.7 KB, 4 views)
File Type: png reference.PNG (4.9 KB, 5 views)
File Type: png output.PNG (5.0 KB, 5 views)

Last edited by Zubairkhan; 03-05-2014 at 12:41 AM.
Reply With Quote
Reply

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 04:16 PM.


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