Remove Duplicates in Excel

In this article we will learn about how we can remove the duplicates items in Excel.

If our data is having large no. of data with duplicate entries, manual deletion would be a very big task and annoyance.

Excel is having in-built option to remove the duplicate entries from data. Remove Duplicate option is under the Data tab in the Data Tools group in Microsoft Excel 2010 and 2013.

Let’s take an example and understand how we can use the Remove Duplicate option.

We have data in range A2:E13. In which column A contains month, column B contains Agent name, column C contains Country name, column D contains sales and column E contains Quantity.
 
img1
 
Data is having duplicate entries. To remove the duplicate entries from data follow below mentioned steps:-

  • Go to Data Tab, click on Remove Duplicates in Data Tools group.

 
img2
 

  • Remove Duplicates dialog box will appear.

 
img3
 

  • In the column box select the columns header on which basis you want to remove duplicate entries.
  • In this data we want to remove duplicate entries on the agent name, we just select the Agent.

 
img4
 

  • After select the criteria as per the requirement of data click on ok.
  • You will get an information popup to inform you that how many duplicates entries were found and how many unique values are left now.

 
img5
 
This is the way you can remove duplicate entries from the large no. of data and can get the data with unique records.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube