Excel Semi Pro
ArticlesFunctionsAI in Excel

Duplicates Articles

Articles tagged Duplicates, including related tutorials, examples, and walkthroughs.

4 articles

FormulasIntermediate
2026-09-15

How to Count Unique Values in Excel

Count unique values in Excel, ignore blanks, count values that appear once, and add criteria. Includes modern formulas and an older Excel alternative....

#unique values#duplicates#data cleanup
8 min read
Read Article
BeginnerFeatures
2019-06-20

How to Remove Duplicates in Excel (and Keep the Right Row)

Remove duplicate rows in Excel, choose the columns that define a duplicate, and sort first to keep the record you want. Includes preview and formula alternatives....

#duplicates
9 min read
Read Article
Intermediate
2010-07-22

Removing Duplicates in Excel 2008

Remove duplicate values from a data set in Excel 2008 for Mac....

#duplicates
2 min read
Read Article
Intermediate
2010-07-17

Removing Duplicate Values in Excel 2003

In Excel 2003 removing duplicate values is a manual process. Here is a method that worked well for me on this particular data set....

#duplicates
2 min read
Read Article

About Excel Semi Pro

Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.

Read more about us
Excel Semi-Pro

Practical Excel guides, formula references, and AI integration tutorials for intermediate users who want to work faster and smarter.

Content

  • All Articles
  • Functions Reference
  • AI in Excel
  • RSS Feed

The Blog

  • About
  • Contact
  • Privacy Policy

Topics

  • Formulas
  • Beginner
  • Advanced
  • Time and Date
  • Charts
© 2026 Excel Semi-Pro. All rights reserved.
Tips, guides, and references for Excel users.Privacy Policy