How to remove duplicate records in excel

How to remove duplicate records in excel

Microsoft excel is a power full software that comes with various features, if you are working or learning excel and looing to remove duplicate records from it, then here I am going to explain all process regarding how to remove duplicate records in excel?

If you are working with huge amount of data in excel, then it is very difficult to remove duplicate data manually from the sheet. Due to this problem, Microsoft Excel comes with a unique feature Remove Duplicates that make it easy. Here we will see how Remove Duplicates option work in excel and where Remove Duplicates option is available in Microsoft Excel.

Step by step process to remove duplicate records in Excel

Step 1: First of all select all cells in which you want to remove duplicate records in excel that I am showing in the picture.

How to remove duplicate records in excel
How to remove duplicate records in excel

Step 2: In the above picture, I have taken 15 records in which “Manish” comes three times. Now we will remove duplicates from the records. To remove duplicates first of all select all cells or you can also select entire A column and then go to data tab in the tab panel. You will see here “Remove Duplicates” option that I have shown in the picture.

How to remove duplicate records in excel
How to remove duplicate records in excel

Step 3: Now click on remove duplicates option, and then a popup will occurs on screen, that will ask you for the confirmation for removing duplicates from selected cells or columns. If your data contains header, then check “My data has headers” otherwise uncheck it. My data doesn’t contains header, so I am not selecting it.

How to remove duplicate records in excel
How to remove duplicate records in excel

Step 4: Now click on ok button, and then you will see 2 duplicates removed from the lists, because I was written “Manish” three times. There is no limits of removing duplicates in excel, you can remove duplicates from multiple columns also.

How to remove duplicate records in excel
How to remove duplicate records in excel

Please contribute us by sharing this blog in social channels or please subscribe our youtube channel.

Create a selection list box in excel

Internet Speed Test

Related Posts