Bill Detwiler shows you how to find duplicate data in Excel by using advanced filters, conditional formatting, and COUNTIF formulas.
Finding all the duplicate information in an Excel spreadsheet can be a challenge. And, you'll often need to use more than one technique to get the job done. During this episode of TR Dojo, I show you how to find duplicates in Excel with the following techniques:
- Advanced Filter options
- Conditional Formatting
- Formulas that concatenate fields and count duplicates (COUNTIF)
For those who prefer text to video, check out Susan Harkin's original article.
You can also sign up to receive the latest TR Dojo lessons through one or more of the following methods:
Subscribe to the TR Dojo newsletter (delivered Tuesdays and Fridays)