Remove Duplicates
Discover how to use Excel to eliminate duplicates.
Working with huge data sets can make the process of manually removing duplicates time-consuming.
Excel’s Remove Duplicates tool makes the process of eliminating duplicates simple.
The method to Remove Duplicates 
To get rid of duplicate entries, click the Remove Duplicates button.
Two or more values that are identical are considered duplicate entries.
Text and number inputs are both possible for this.
Example
A1(5), A2(5), A3(2)
A1 and A2 are duplicates since they have the same values.
How to remove duplicate values
Step 1) Select a range:
Choose the range from which duplicate values should be eliminated.
There must be values in at least two of the cells.
Excel will automatically add cells that are related.
This aids in preventing the cellular relationships from being broken.
Step 2) Click the Remove Duplicates button:
Locate the button in the ribbon under the Data tab.
Click the button to initiate the command.
Step 3) Select columns:
Choose a column or columns with values.
Once you have chosen the columns, click the “OK” button.
Duplicates removed
The duplicates have been eliminated after selecting the columns and clicking the “OK” button.
Example:
We will eliminate the duplicates for Column B (Age) in this case.
Choose Column B (Age) :
Press the “OK” button…
1 duplicate value was removed.
3 unique values remain.
Advice: Take caution while using the Remove Duplicate method on big data sets.
Misuse could lead to the removal of important data.
