Leadership optimize

Video: Three ways to find duplicates in Excel

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:

Follow Bill Detwiler on Twitter

Subscribe to the TR Dojo newsletter (delivered Tuesdays and Fridays)

Subscribe to the TR Dojo RSS feed

Sign up for customizable TR Dojo e-mail alerts

Access TR Dojo from your mobile device

About

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 supp...

3 comments
Chester Nimitz
Chester Nimitz

Whenever I click on the download link it goes to BNet and doesn't do anything else. I'm on Google Chrome for VISTA. ANybody else having this problem. The information is very useful.