Compare Tables for Excel is a powerful add-in for finding the differences between two tables in Excel.
Do you need to compare the sales report monthly to find the differences between two reports? This add-in can be used to help you quickly finish the job.
The add-in can be used to compare every rows, columns and cells of two Excel tables. You can choose the headers and first columns of two tables are used as comparison criteria:
Header is used as comparison criteria: The add-in will compare every column of 1st table with 2nd table is based on the same content of the header. The comparison is not column by column or row by row.
First column is used as comparison criteria: The add-in will compare every row of 1st table with 2nd table is based on the same content of first column. The comparison is not row by row or column by column.
If you do not choose these options, the add-in will compare two tables cell by cell.
After comparing, the add-in will mark the modified cells with blue, deleted cells with red and added cells with green on the original tables. You can look for the differences of two tables quickly with the different colours.