excelformulae
New Member
- Joined
- Jul 4, 2018
- Messages
- 6
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 table. 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
Expected sample result:-
<tbody>
</tbody>
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 table. 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
Expected sample result:-
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 |
<tbody>
</tbody>