How to Remove Duplicates In Excel

bardimin pic

Written by Bardimin

On December 31, 2021
Home » Blogs » Technology » How to Remove Duplicates In Excel

Duplicate data in Excel is sometimes a big problem when you try to understand it.

Finding duplicate data manually is certainly very tiring if the data is large.

With , finding and removing duplicate data is very easy.

Finding duplicate data in Excel

  1. Select the cell that you want to check for duplicates
  2. Click “ Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values”
duplicate excel 01
  1. In the window that appears, select the duplicate format you want. Then click the “OK” button
duplicate excel 02
  1. Duplicate data will be marked with the format you selected in step 3.
duplicate excel 03

Remove duplicate data in Excel

After you review the duplicate data that you found in the example above, you can remove the duplicate data by:

  1. Select the cell that you want to delete the duplicate from .
  2. Click “ Data > Remove Duplicates”
duplicate excel 04
  1. Select the duplicate reference column. In this example, we will delete the duplicates in the “City” column. Then click “OK”.
duplicate excel 05

will keep the first row of duplicates and will remove duplicates after it.

  1. Excel will tell you the number of duplicate rows removed. And the result will look like the following
duplicate excel 06

Latest Articles

How to Restrict Data Input in Excel – Allow Only Certain Values

How to Restrict Data Input in Excel – Allow Only Certain Values

In Excel, you can restrict users by only allowing data input with the values you have specified. In this article, Bardimin will share some tricks to only allow the input of specific values in Excel cells. Data entry errors are a problem for any Excel user who wants...

How to Sum Number Columns and Rows in a Microsoft Word Table

How to Sum Number Columns and Rows in a Microsoft Word Table

Microsoft Word is known as a popular program for editing documents, but did you know that you can also perform calculations in Word? One of the biggest challenges faced during the manual data entry process is the possibility of errors in performing numerical...

Redirect and Block URLs with HOSTS File on Windows

Redirect and Block URLs with HOSTS File on Windows

Redirect and Block URLs you can easily on Windows. Just by adding the IP of a website, you can redirect or block it. Of course, this is very useful to limit the access of your employees or children from accessing websites that you do not allow. Your Windows PC has...

Repeating and Keeping Table Headings on Each Page in Microsoft Word

Repeating and Keeping Table Headings on Each Page in Microsoft Word

Using tables is one efficient and organized way to display data in rows and columns. Good table formatting will make the table visually appealing. If you often work with Microsoft Word documents, chances are you need to periodically use tables when recording data. In...

How to Bypass Forgotten BIOS Password

How to Bypass Forgotten BIOS Password

If you have created a BIOS password for your PC/Laptop and forgot it, you may have to send it back to the manufacturer. Don't worry, there are still several methods you can use to bypass or unlock the BIOS password. The BIOS password serves as a form of authentication...