Compare 2 tables
To compare two tables stored on the Excel worksheets you need to decide if your table has heading and key columns.
Why this is important?
Key columns identify rows in the table. To compare 2 tables correctly xlCompare needs to identify matching and mismatching rows. Key values are the only way to do this.
If you are working with unsorted tables - this is highly important.
What will happen if I don't define key columns?
In this case xlCompare tries to find the best match for every row.
For example, you have two tables with prices. Values like Samsung UE43DU7100UXUA and Samsung UE43T5300AUXUA could be marked as changed, if other cells in these rows are similar.
And they are located on the same place in both Excel sheets.
But if you select key column - this pair of rows will be always treated as different.
Worksheets compared without key columns
Worksheets with key columns and heading
Apple was found on the other worksheet.
