Removing Duplicate Records In Excel Super-fast.

Asked By krystlejharris 20 points N/A Posted on - 05/11/2017

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?

• Status: Open
• Question Views: 309
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: Excel | records

Answered By Ronald R Schrupp 0 points N/A #296576

Removing Duplicate Records In Excel Super-fast.

Iterate these steps in MS-Excel:

1. You can use Remove Duplicates command on the Data tab of Data Tools group.
2. Select the cell range and click Remove Duplicates on the Data tab.
3. You can select and clear all the columns by selecting them all.
4. Click OK. It will display the no. of duplicate values that have been removed and also the remaining number of unique values.
5. Accept it positively by clicking OK.

About Ronald R Schrupp

Questions
3

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/11/2017
• Question Category: MS Excel