1. Home

How to Remove Duplicates with Excel

Learn how to remove duplicates with Excel

How to remove duplicate values

Step 1) Select a range:

Select the range where you want to remove duplicate values.

A minimum of two cells needs to have values.

Excel will automatically include related cells.

This helps so that you do not break the relationship between the cells.

Step 2) Click the Remove Duplicates button:

Find the button under the Data tab in the ribbon.

Start the command by pressing the button.

Excel Skills for Business Specialization
Step 3) Select columns:

Select one or more columns that have values.

Press the "OK" button once you have selected the columns.

Duplicates removed

When the columns have been selected, and you have pressed the "OK" button, the duplicates have been removed.

Example:

In this example, we will remove the duplicates for Column B (Age).

Select Column B (Age):

Press the "OK" button...

1 duplicate value was removed.

3 unique values remain.

Tip: Use the Remove Duplicate function with care for large data sets.

If used wrong, it might remove useful data.

Categories

HTML CSS3 Bootstrap Foundation Sass JavaScript TypeScript JQuery AngularJS React NodeJS Highcharts PHP Python Python3 Django Linux Docker Ruby Java C C ++ Perl Servlet JSP Lua Scala Go ASP C # SQL MySQL SQLite MongoDB Redis Android Swift ionic Kotlin XML tutorial

Contact US