Get hands-on help with Vocordia
You can do it the hard way - reading guides, switching tabs, figuring it out step by step.
Or you can do it the easy way.
Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.
How to Find Duplicates in Excel
It is usually safer to find duplicates before removing them. Highlighting repeats helps you confirm what Excel considers a duplicate for your chosen rules.
Highlight duplicates with Conditional Formatting
- Select the range you want to check (a single column is common).
- Go to Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values.
- Choose a style and click OK.
Find duplicates across multiple columns
For row-level duplicates, create a helper column that concatenates key fields (or use a formula that counts repeated combinations), then apply formatting or filter.
Use a formula to flag duplicates
Functions like COUNTIF can mark rows where values appear more than once. For example, in a helper column, count how often a key appears in the full range and filter where the count is greater than one.
Microsoft 365 shortcut
In newer Excel, you can sometimes leverage dynamic array functions to list or filter duplicates non-destructively, depending on your layout.
Try it faster with guidance
Skip the trial-and-error—let Vocordia guide you through it with voice and on-screen guidance so you can spot duplicates without guessing the right range.
Had to scroll back or switch tabs a few times?
That's the hard way.
Next time, just say what you want - and let your cursor guide you step by step to the result.