Imagine you have a huge spreadsheet of entries and you need to check to make sure that there are no repeated records. Now, you can go through each entry and manually check, but visualize checking 10,000records for this. Time consuming, isn’t it? Fortunately, Excel comes with a ‘Remove Duplicates’ feature.
Select a range of data, click the Data tab and then click Remove Duplicates.This will bring up a new window in which you can specify the columns in which Excel would check. After clicking OK, Excel will then remove all duplicate records.