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, 10:57 PM
Zubairkhan Zubairkhan is offline Windows 7 32bit Office 2007
Novice
  
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, 10 views)
File Type: png reference.PNG (4.9 KB, 11 views)
File Type: png output.PNG (5.0 KB, 11 views)
Last edited by Zubairkhan; 03-05-2014 at 12:41 AM.
Reply With Quote