Get matching and mismatching rows

To display only matching or mismatching items in the comparison report - use filter buttons on the Ribbon.

No filter is applied. All rows are visible. This is the default selection.

Rows that have identical cells. Every cell is the same as the cell in the corresponding row.

Rows where at least one value was updated.

Combination of matching rows and updated rows.

Rows that don't have corresponding item on the other worksheet. This is added and removed rows.