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