| Be My Friend

Remove Duplicates in Excel

Remove Duplicates | Shortcut | Examples | Using Advanced Filter

Using the 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.

It 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 manually, in such type of scenario, Remove Duplicates in Excel helps you to remove duplicate values in the column.

Shortcut to Remove Duplicates in Excel: ALT + H + L


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

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 duplicates 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.

Click Duplicates

3. you will get the below dialog box.

Remove Duplicates 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 Result

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 rows.

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

Click Advanced Filter

3. you will get below dialog box.

Advanced Filter Dialog Box

4. Here, the List range is Selected data, and Copy to is the cell where we need to extract unique records.

5. Click OK.

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

Advanced Filter Result unique Values

You May Also Like the Following Excel Tutorials:


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

To Get FREE Excel Shortcut Keys



Why basictutorials.in?

To Learn:

Tutorials in a simple Way.

Excel with downloadable samples.

HTML with sample website code.

PowerPoint presentations.

MS Word for offical use.

Useful Tutorials