Rollno
| Reviewer
|
1 | Ankit |
| b |
| a |
2 | Priya |
| a |
| c |
| b |
Rollno
| Reviewer
|
1 | Chapter 1 |
| a |
| b |
| c |
2 | chapter 2 |
| b |
| a |
| c |
| d |
Hi friends ,
I want to compare cells of two workbooks1 (master) and Workbook2 (Answer) .Comparison should be done cell wise but the order of data is different in both sheets, moreover some data are missing in workbook2 (Answer) .Plz check the example for more clarification .Is there any other alternative to solve this issue either by using vlookup or any other technique.
Workbook2 Workbook1
But I want to compare both cells of the reviewer and master and check whether its correct or not. And it should compare all the cells of master with answer .If I would be able to consolidate the sheet (ex shown below) then it will be easy for me. Please help me if any other alternate is there.
Rollno
| Reviewer
| Rollo
| Reviewer
|
1 | Chapter 1 | 1 | Ankit |
| a | | a |
| b | | b |
| c | | |
2 | chapter 2 | 2 | Priya |
| b | | b |
| a | | a |
| c | | c |
| d | | |
Regards
Jyothish KC
Best Regards,
KC
