View SpicyFlavours Stats
Jump to content
Positive Zeal
Sign in to follow this  
  • entries
    10
  • comments
    0
  • views
    2,247

Remove repeated entries easily in Excel

saurabhjain

530 views


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.

excel.png

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.

 

 



0 Comments


Recommended Comments

There are no comments to display.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×