How to Remove Duplicate Data in Excel Easily and Quickly

How to Remove Duplicate Data in Excel Easily and Quickly

Geekers - Data duplication in Excel means that there is the same data or record in a table in Excel. In processing data in Excel, the required data must not contain duplicate data because it will complicate the processing or analysis of the data.


Why should duplicate data be cleaned? If this happens to the data of a company then this will have a negative impact on the company. For example, on cost efficiency, if your company sends gifts to customers 3 times when it should only be enough once. This is because, there is duplication of data on the customer's name, of course this will be detrimental to the company if gifts are sent not only to one customer but dozens of duplicate customers.



For this reason, it is important to clean up duplicate data in the data cleansing process to avoid various errors that might occur. For a more detailed explanation, let's look at the explanation below.


Other Interesting Articles:

   * Tutorial on how to lock an Excel file with a password

   * How to Make Text or Vertical Writing in Microsoft Word

   * Guide on How to Install Windows 10 for Beginners


How to Delete Double Data (Duplicates) in Excel


How to remove duplicate data in Excel? The method is quite easy and simple. Below are the steps to remove duplicate data in Excel.



1. First, open the Excel worksheet of the data that you will clean from duplicates. Select the cells that you will delete duplicate data from.


2. After that, select Home > Conditional Formatting > Highlight Cell Rules > Duplicate Values as indicated by the arrow in the image below.


How to Delete Duplicate Data in Excel How to Delete Duplicate Data in Excel


3. Then, the Duplicate Values window will appear. Here, you can change the highlight type for duplicated data by selecting the format you want in the values with box. Then click OK.


Removing Excel 1 Duplication Removing Excel 1 Duplication


4. Well, the result will look like in the image below. In the image below, duplicate data is given a red background color.


Removing Excel 2 Duplication Removing Excel 2 Duplication



5. Now to remove it, select Data > Remove Duplicates as indicated by the arrow in the image below.


Removing Excel 3 Duplication Removing Excel 3 Duplication


6. Then, the Remove Duplicates window will appear, here I tick all the columns because I want to delete every duplicate record. Click OK.


How to Remove Duplicate Data in Excel How to Remove Duplicate Data in Excel


7. The result will look like in the image below. Duplicated data in the table below has also been deleted (lost). Now your table is clean from duplicate data.


Removing Excel 5 Duplication Removing Excel 5 Duplication


8. But your table still has flags in certain cells. To delete it select Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet.


How to Remove Duplicates in Excel How to Remove Duplicates in Excel


9. The final result of deleting duplicate data in Excel will look like the image below.


Removing Excel 7 Duplication Removing Excel 7 Duplication



That's all the discussion on how to remove duplicate / duplicate data in Excel easily and quickly. All right, I hope the discussion that has been explained above is useful and good luck. Thank you!

Share:

Top Ads

Responsive Ads

Bottom Ads

Responsive Ads