Hello Friends,
I want to compare two subsequent rows and highlight all the differences.
Example - Treat source A row as the correct data. If source B row data mismatches source A row, highlight it automatically as shown. There are about 60 values to compare (62 columns) and about 20,000 rows in the excel.
<tbody>
</tbody>
I'm using MS Office 2016.
Thank you!
I want to compare two subsequent rows and highlight all the differences.
Example - Treat source A row as the correct data. If source B row data mismatches source A row, highlight it automatically as shown. There are about 60 values to compare (62 columns) and about 20,000 rows in the excel.
employee_id | salary | department | |
source A | 100 | 300 | A |
source B | 100 | 350 | A |
source A | 230 | 400 | D |
source B | 230 | 400 | E |
source A | 500 | 550 | T |
source B | 500 | 590 | T |
source A | 400 | 490 | W |
source B | 400 | 460 | E |
<tbody>
</tbody>
I'm using MS Office 2016.
Thank you!