Detect duplicate keys
When the selected key appears more than once, SheetDiff adds duplicate warnings to the comparison report instead of guessing which rows should match.
When the selected key appears more than once, SheetDiff adds duplicate warnings to the comparison report instead of guessing which rows should match.
Pro users can generate a duplicate review sheet that lists candidate rows and lets the user choose which records should be paired.
After duplicate choices are applied, SheetDiff regenerates the report with updated missing rows, changed rows, and matching rows.