How to Remove Duplicates In Excel

31 December 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 > > Highlight Cells Rules > Duplicate Values”
TOP TUTORIALS:  NewPipe – Ad-Free YouTube App for Android
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”.
TOP TUTORIALS:  Easy Ways to Change List Separator on Function in Excel
duplicate excel 05

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

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