• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Remove Duplicates in Excel

April 26, 2021 by Andrew Childress
Delete duplicates Excel

When you're working with a large amount of data, you may find duplicate values within the data. Here's how to remove duplicates in Excel.

When you’re working with a large amount of data, you may find duplicate values within the data. On some occasions, you need those values. But on others, you want to keep only unique data. Excel makes this a breeze. Let’s learn how to remove duplicates in Microsoft Excel.

How to Remove Duplicates in Excel

Consider a list with multiple columns of data. Glancing through, you can identify certain duplicate values that appear. Of course, you could delete these manually, one by one. But Excel has a built-in feature called Remove Duplicates that does the hard, tedious work for you.

To get started, go ahead and select the range of data that you want to analyze and remove duplicate values from. In this case, that’s cells B1:B7.

Then, go to the Data tab on Excel’s ribbon. The Data tab is filled with easy-to-use analysis options that help you work with data more effectively. The option you want is called Remove Duplicates. You’ll find it just right of center on the Data tab menu.

Delete duplicates Excel

Go ahead and click on Remove Duplicates. You’ll see a popup menu appear, asking for a series of key inputs. The checkbox at the top asks if your data has headers. This dataset doesn’t, so leave this option unchecked.

Below, you can select the column to analyze, which here is column B. 

Delete duplicates in Excel

When you’re finished, press OK. Excel will display a popup window, detailing how many duplicate values were found and removed. It also displays how many unique values are contained in, and therefore remain, in your data. Notice that duplicates have disappeared from the list. Click OK again to clear the popup window.

How to delete duplicates in Excel

As you can see, Excel makes it easy to remove duplicate values, with no need to manually process your data.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Combine names ExcelCombine First and Last Names in Excel
Next Post:Add Columns in ExcelAdd columns in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top