▷ How to Eliminate Duplicates in Excel | remove duplicates easy
Oh Snap!

Please turn off your ad blocking mode for viewing your site content

img

▷ How to Eliminate Duplicates in Excel | remove duplicates easy

/
/
/
297 Views

WHAT IS IT ?

Eliminate duplicates in excel is a tool that allows us to remove repeated data either in rows and/or columns.

When we work with a lot of information contained in several rows and/or columns, it is difficult to realize if there is repeated data which can affect the results of what we are doing, so the tool to eliminate duplicates in excel turns out to be useful in these cases.

WHAT IS REMOVING DUPLICATES FOR?

It is important to learn how to eliminate duplicates in excel to validate that the information has unique data and thus obtain better results. 

IMPORTANCE OF REMOVING DUPLICATES

To remove or eliminate duplicates, it is important to take into account that the Excel tool may seem simple to carry out this action, but you must know how to correctly choose the fields to eliminate duplicate data and not just other information. 

Observe the following table in which the rows and columns are indicated for a better understanding:

remove duplicates in excel

HOW TO REMOVE DUPLICATES?

In the previous table we indicate the rows and columns to facilitate interpretation when eliminating duplicate data. The path to remove duplicates is as follows:
 
  • Select the table (you can also select a single cell within the table) > Data > Remove Duplicates > a window will appear.
remove duplicates window

Example 1

1. The above contains the information table headers, if syou choose all and you give to accept, only row 8 will be removed because it has all the duplicate data from row 6. 

The filter to eliminate duplicates will take all the duplicate information from the entire table, which is correct since we will have unique values to interpret.

Example 1 how to remove duplicates

Example 2

2. If we remove the header from the list DATE, the data in row 8 will be removed because this option searches the other columns for exactly duplicate values in POPULATION, SEX AND SECTOR and does not take into account the DATE column:

  • On the contrary if we select only the DATE and not the other headers, all duplicates will be removed from the column a and the duplicate data of the other columns will not be taken into account:

Example 3

3. If we remove from the list the header of POPULATION, the data in row 7 and 8 will be removed because they are exactly duplicate values from row 5 and 6 in DATE, GENDER AND SECTOR:

  • Conversely, if we select only POPULATION, duplicates are removed column b and the duplicate data of the other columns will not be taken into account:

Example 4

4. If we remove the header from SEX, the data in row 8 will be removed because they are exactly duplicate values from row 6 in DATE, POPULATION AND SECTOR:

  • Conversely, if we select only SEX, duplicates are removed from the column c and the duplicate data of the other columns will not be taken into account:

Example 5

5. If we remove the header SECTOR, the data in row 8 will be removed because they are exactly duplicate values from row 6 in DATE, POPULATION AND SEX:

  • Conversely, if we select only SECTOR, duplicates are removed from the d-column and the duplicate data of the other columns will not be taken into account
  •  Since there is only one sector called NORTH that is repeated several times, then we will have only one row with information:

VIDEO: REMOVE DUPLICATES

    This div height required for enabling the sticky sidebar
    en_USEN