remove duplicate record in Excel

Q4. In a "Table", how can I remove duplicate records?

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 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 excel 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 excel excel excel remove duplicate record


You can find similar Excel Questions and Answer hereunder

1) How can I export a WorkSheet as a PDF using VBA?

2) I frequently use a Macro - is there a way to quickly access the Macro in the Excel Ribbon?

3) How can I dynamically add a hyperlink using VBA?

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

5) How can I loop through all WorkSheets and get their names using VBA?

6) How can I get row count of filtered data?

7) How can I remove Outline from my WorkSheet?

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

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

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

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

12) Remove the apostrophe cell text values in Excel

13) How can I enter a text in a cell with subscript and superscript?

14) How can I ensure that important files always appear on the recent Excel workbooks list?

15) I have several pictures that are misaligned - manually aligning them is very laborious. Is there an automatic alignment option?