Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Compare 2 reports and merge data to third report

Hi
I have extracted data from 2 reports and merge the data in the 3rd report.
Here are the report formats
Report 1: Report 2:

Ticket Priority Ticket Time
123 P1 235 3
124 P2 123 4
234 P3 234 5

I need the 3rd report
Ticket Priority Time
123 P1 4
234 P3 5

Can anyone help me to pull this report.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge data for a report conditional merge data into a newmaster Excel Worksheet Functions 0 June 11th 08 12:18 AM
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report Prashanthi Setting up and Configuration of Excel 0 February 18th 08 03:02 PM
compare and merge data tourmaline Excel Worksheet Functions 0 March 13th 06 05:27 PM
VLookup to merge Access Query data into Excel Report Vira-SJH Excel Discussion (Misc queries) 0 January 10th 06 07:18 PM
pivot reports - limit report to last 20 dates Pivot Help Excel Worksheet Functions 1 March 1st 05 09:08 PM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"