Hi All
After searching a lot , I did not find any solution here and on web, Actual I would like to compare sheet1 a col with sheet2 a col and copy result on sheet "Comparing Result" both comparing sheets several duplicate values, I don't want to remove duplicates values when copying result , Please go through below detail of sheet "Comparing Result"
Comparing Result
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 281px;"><col style="width: 64px;"><col style="width: 339px;"><col style="width: 339px;"></colgroup><tbody>
</tbody>
Sheet1
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Sheet2
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
After searching a lot , I did not find any solution here and on web, Actual I would like to compare sheet1 a col with sheet2 a col and copy result on sheet "Comparing Result" both comparing sheets several duplicate values, I don't want to remove duplicates values when copying result , Please go through below detail of sheet "Comparing Result"
Comparing Result
A | B | C | D | |
1 | Inclusive all repeated values in both sheets | Inclusive all repeated values which are not in sheet1 | Inclusive all repeated values which are not in sheet2 | |
2 | Values in Sheet1 & Sheet2 | Value Not in Sheet1 | Value Not in Sheet2 | |
3 | 1345 | 5897 | 4789 | |
4 | 1356 | 1345 | ||
5 | 1234 | 4789 | ||
6 | 1345 | 1234 | ||
7 | 1652 | |||
8 | 4789 | |||
9 | 1345 | |||
10 | 1789 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 281px;"><col style="width: 64px;"><col style="width: 339px;"><col style="width: 339px;"></colgroup><tbody>
</tbody>
Sheet1
A | |
1 | List A |
2 | 1345 |
3 | 1356 |
4 | 4789 |
5 | 1234 |
6 | 1345 |
7 | 1652 |
8 | 4789 |
9 | 1345 |
10 | 1789 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"></colgroup><tbody>
</tbody>
Sheet2
A | |
1 | List B |
2 | 1345 |
3 | 1356 |
4 | 5897 |
5 | 1234 |
6 | 1345 |
7 | 1652 |
8 | 4789 |
9 | 1345 |
10 | 1789 |
11 | 1345 |
12 | 4789 |
13 | 1234 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 64px;"></colgroup><tbody>
</tbody>