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 Excel, 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”.
TOP TUTORIALS:  Creating a Virtual Machine in Windows 10 Without Application
duplicate excel 05

Excel 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
Ads Blocker Image Powered by Code Help Pro
Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

I Have Disabled The AdBlock, Reload Now
Powered By
CHP Adblock Detector Plugin | Codehelppro