Lesson#136: Learn how Remove Duplicates works

Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In this post you will learn how Remove Duplicates in Excel works and when and why to use.

See in the above picture I made a list of names of cements and making companies for an example. These names are used repeatedly in these two columns. Suppose we need to remove all the duplicate values from one column then we can select the column and just click on Data>Remove Duplicates

See in the above picture I have selected the option My data has headers so the column is being named Material. Now just click on the OK button.

Now if we need to remove the duplicate values by keeping the data combination of multiple columns (For Example: CEMENT OPC 53 in column A and ULTRATECH in column B together is an unique value). Then select both the columns and then go to Data> Remove Duplicates.

Now just click the OK button.

When to use the Remove Duplicates?

This feature useful in many cases as per your requirement. Some useful tips I will share. Whenever you need to make an summary from the data table with SUMIF, COUNTIF, SUMIFS, COUNTIFS functions then you can copy the table data to other sheet or other area of worksheet then apply this feature.

I will suggest Pivottable if your data table is too big.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Leave a Reply

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