How to use
Prepare two source lists with a consistent key. Open Compare Datasets, select the ranges/columns in the prompts and inspect the match or difference outputs. Check the result before saving changes.
Assist Pro+ / Audit and Analysis
Compare Datasets
Identifies matching, duplicate and unique records between two datasets.
Where to find it
Follow the ribbon path.
Assist Pro + → Audit and Analysis → Data Compare → Compare Datasets
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsPractical guidance
Use this tool in your workflow.
Best use case
Finding matched, missing or duplicated records across two datasets.
Everyday Excel
Avoids checking two spreadsheets row by row when you need to identify matching, duplicate and unique records between two datasets.
Accounting and audit
Speeds comparisons of prior-year data, client records and testing schedules by helping identify matching, duplicate and unique records between two datasets.