How to Remove Duplicates in Excel?

Remove Duplicates | Shortcut | Examples | Using Advanced Filter

Using Remove Duplicates in-built tool in Excel, it is easy to remove duplicate values in Excel. we can remove duplicate values in a range of cells, which means, if the range of cells contains value more than one time and you want to delete duplicate values. it is difficult to delete one by one, in such type of scenario, Remove Duplicates in Excel helps you to remove duplicate values in the column.

Shortcut to Remove Duplicates in Excel is, ALT + H + L

Remove Duplicates Examples:

The below examples teach you how to remove duplicates in Excel.

In the above example, we have a list of State Names with Values, but if you observe State Names, Karnataka State name repeated thrice.

Now, if you want to keep Karnataka State's name with Value one time, then Remove Duplicates will do that work. to find how many duplicates are there in column or range, you can use Conditional Formatting or Pivot Tables.

CTRL + F is the shortcut to find multiple entries.

To Remove Duplicates follow the below steps.

1. Select the range where you want to Remove Duplicates or put the cursor on any single cell on that data set.

2. Go to Data Tab, Data Tools Group, Click on Remove Duplicates.

3. you will get the below dialog box.

4. If you want to remove duplicates from the header, then uncheck My list has headers.

5. In this example, we want to remove duplicates from full data. if you want to remove duplicates from a particular column you can select that column.

6. Click OK.

Below is the result after Removing Duplicates.

Remove Duplicates Using Advance Filter:

Advance Filter extracts unique values from selected row to another row. let's take one more example,

1. Select the range or column that you want extract unique values.

2. Go to Data Tab, Sort & Filter Group, Click on Advanced.

3. you will get below dialog box.

4. Here list Range is Selected data and Copy to is cell where we need to extract unique values.

5. Click OK.

Result: Excel Extracted unique state names into the column D.

You May Also Like the Following Excel Tutorials:

• How to Separate Texts in Excel?
• How to use the TRANSPOSE Function in Excel?
• Group and Un-Group in Excel.
• Multiple Types of Addition in Excel.
• How to use Charts in Excel?

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.