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)
Bill Detwiler has nothing to disclose. He doesn't hold investments in the technology companies he covers.
Bill Detwiler is Managing Editor of TechRepublic and Tech Pro Research and the host of Cracking Open, CNET and TechRepublic's popular online show. Prior to joining TechRepublic in 2000, Bill was an IT manager, database administrator, and desktop support specialist in the social research and energy industries. He has bachelor's and master's degrees from the University of Louisville, where he has also lectured on computer crime and crime prevention.