| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare two columns and display value in 3 cloumn | Excel Discussion (Misc queries) | |||
| Compare several columns of data and display unique ones | Excel Discussion (Misc queries) | |||
| compare two columns and display a third | Excel Discussion (Misc queries) | |||
| Compare and display multiple rows | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Threaded Mode
