But the tool has decided, that the matching row is the sixteenth one, and the seventeenth is colored as unique.

Compose your response just once, save it as a template and reuse whenever you want.

These sheets may have a different number of rows or include one or even several tables.

It is important to preserve the structure of these sheets and avoid comparing, for example, header rows with the main table rows.

I will use the Ablebits Compare Two Sheets tool and its No key columns comparing mode.

In brief, the sheets you compare should be saved and should not be protected.

The worksheets should have the same structure, including groping, filtering, and sorting.

This is important to avoid comparing, for instance, header rows with regular table rows.

Your invoices may be in the same Excel book or in different files.

The tool offers you three comparing modes for different types of sheets.

The point is that the matching options work for only lines that are not identical in your sheets.

In such cases, for a row in the first worksheet, the tool may find several possible matching rows in the second sheet.

It will not look for any other matches in other columns of these rows.

If there are other rows in Sheet 2 that contain the same value, they will be marked as unique.

The row that has the maximum number of the same values will be considered matching, and the cells that are different will be colored.

If you select it, there wont be any partially matching rows - either fully matching lines, or unique ones.

In the matching rows, different cells will be colored in green.

Here is the toolbar that lets us perform various actions with the found differences.

Why are these cells colored They look identical, but here I have a misprint, letter I is missing in the Invoice word.

These rows are matching because the values in the first columns are the same.

The different cells in the matching rows are colored in green.

Again, it is colored in green, because empty cells are matching, making the entire rows matching as well.

The first sheet contains two items, the second sheet - three, but one of them is duplicated.

No problem with item 1 - the price, quantity, and subtotal are the same.

Microsoft Excel For +Mac 2011 Version 14 Spreadsheet Compare