Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Remove Duplicate Values In MS Excel 2007

Let's discuss today as to how we can delete duplicate values from rows and columns in a specific worksheet in Excel. Consider the database shown below for this: As you see above the last three entries are repeated in the database. Considering this is just an example and thus a small database, it is easy to manually delete the last three rows but imagine how tedious it would be delete all the duplicate entries of a database consisting of 50,000 lines. So to make it easy do the following: Select the entire data range and point to “Data” and click on “Remove Duplicates” under “Data Tools” and you will be able to see a text box as show below. The headers will be listed in the columns details. Since we need to remove the entire row which is duplicating, so just click on “OK”. As soon as you click on “OK” you will see a dialog box which opens up telling you the number of duplicate values which got removed. Click on ok and you are done with removing the duplicate values. You can also delete duplicate values from a particular column or row as well but do remember doing so will leave the adjacent values as they are. Let us show you by trying to delete the duplicate values in the place column. Select the place column values and point to “Data” and click on “Remove Duplicates” under “Data Tools”. As seen above, the moment you click on “Remove Duplicates” you will be prompted with a dialog box. Lets explain both the options: • Expand the selection: Checking this and clicking on Remove Duplicates in the dialog box will select the entire database. • Continue with the current selection: Checking this and clicking on Remove Duplicates in the dialog box will only delete values from the “Place” column. Let select the second option as we have already demonstrated the first option above. Going further you will be prompted with a dialog box and we will follow the same as what we did above. So just click on “OK”. As soon as you press “OK” [just like its mentioned above] you will be shown the number of duplicate values deleted and unique values remaining. Click “OK” to close the dialog box. That completes the task and you are done with deleting the duplicate values.
0 comments:

Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits