Forum Discussion
Excel display common values of its corresponding values
Hi sir/Madam,
I am really struggling to compare and display the values in excel.
My requirement: I have excel sheet with two tabs. First tab has two columns A and B. A is having values of incident id and B is having corresponding dates. In same way Second tab also has two columns A and B . A is having values of incident id and B is having corresponding dates. Some values of column A of first tab has matches in second tab column A. So I want to display those matched values of Column A of first and second tabs and their (column A's) corresponding values from column B of both tabs in separate tab in the format as below. I have highlighted I have attached excel spreadsheet. I am really in need of this. It would be appreciated if someone help me on this. Thanks in advance
Display values common in Column A of First and second tabs (Highlighted in yellow) | Display the column A’s corresponding value in column B of First tab (Highlighted in yellow) | Display the column A’s corresponding value in column B of Second tab (Highlighted in yellow) |
INC000018208304
| 4/30/2018 16:30
| 5/1/18 2:00
|
INC000018208291
| 4/30/2018 16:24
| 5/1/18 1:54
|
Hi Gouse,
It looks like in your sample all ID:s from second sheet are in first one plus some ID:s are repeated.
Anyway, the easiest id to do with Power Query - load tables from both sheets, merge them with inner join on ID and return result to Excel sheet.
