View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default Compare columns and display the value

Hi All

I have pulled data from 2 different reports here is the Data
Report 1 :
Ticket Priority
123 P1
124 P1
125 P3
126 P1

Report 2:
Ticket Time
123 3
128 4
127 3
124 5

Now i want build a 3 report where the Ticket has to compare and display in
the below format If the ticket is avialable in Report 1 and not in Report 2
then the Report 3 has to display only Ticket and Priority.

Ticket Priority Time

Is it possible to get the data in Excel please help me