I have done works in Excel and by accident created a lot of duplicate records. How can I remove these duplicate records in excel without any trouble?
Removing Duplicate Records In Excel Super-fast.
Iterate these steps in MS-Excel:
- You can use Remove Duplicates command on the Data tab of Data Tools group.
- Select the cell range and click Remove Duplicates on the Data tab.
- You can select and clear all the columns by selecting them all.
- Click OK. It will display the no. of duplicate values that have been removed and also the remaining number of unique values.
- Accept it positively by clicking OK.