Tools Vault selection / Pro+ collection
Use Tool Finder if you do not know the ribbon group. Confirm the final location in your installed version.
Tool guide
Find possible duplicates
You need to locate repeated rows, references or combinations of fields.
What it solves
Use this when…
You need to locate repeated rows, references or combinations of fields.
Expected result: A set of possible duplicates for review, not automatic proof that records are wrong.
How to use
Follow these steps
Try the action on a copy of your workbook first.
1
Define what counts
Decide whether to compare an entire row or chosen identifying columns.
2
Select the data
Check headers and exclude unrelated totals.
3
Run and review
Inspect flagged rows before removing or changing anything.
Before you finish
Check the output
Confirm the result against the source and keep your own judgement in the loop.
Unexpected input format
Check headings, selected ranges and text/number formats before running. Work on a copy for consequential changes.
Ready to explore?
Make Excel work better for you.
Start with the current 10-day trial, or speak to us about what your team needs.