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.
Data is having duplicate entries. To remove the duplicate entries from data follow below mentioned steps:-
This is the way you can remove duplicate entries from the large no. of data and can get the data with unique records.
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.