Remove duplicate record in Excel

For example, Table below lists the Quarter wise Sales data in the Year 2016 for all Salespersons in a Company collated from multiple worksheets. There is a duplicate record for "Linda Johnson". In Excel, how can it be removed?

Note: This is a small Table for illustration purposes - hence duplicate(s) can easily be identified manually. However when there are large number of records, manual process is very tedious and error prone.

excel remove duplicate record

To do it in Excel, here is the answer:

To remove duplicate records in a Table,

a) Click on any cell in the Table. In the Ribbon, "Table Tools" Design tab appears. Click on "Remove Duplicates" under "Tools".

excel remove duplicate record

b) In the "Remove Duplicates" dialog box that appears, click on columns that contain duplicates. In this example case, we are interested in First Name and Last Name columns.

excel remove duplicate record

c) If there are duplicate records, they are removed and a prompt appears indicating how many duplicate records were found and removed and how many unique values remain.

excel remove duplicate record


You can find similar Excel Questions and Answer hereunder

1) How can I remove hyperlinks from a range of cells?

2) How can I prevent users from entering duplicate values in a range?

3) Remove the apostrophe cell text values in Excel

4) How can I find the sum of records that meet a given condition in my raw data table?

5) How can I remove display of Gridlines in my worksheet using VBA?

6) How can I find the count of records that meet a given condition in my raw data table?

7) How can I quickly remove all blank cells in a data range?

8) Is there a way I can easily identify the duplicate values in a dataset?

9) How can I remove Outline from my WorkSheet?

10) How can I remove all nonprintable characters from text?


Here the previous and next chapter