Question of the week of 9/12/11 – Remove duplicate values in Excel

Question: Is there a way to remove duplicate values from a long list of names in Excel?

Answer: Yes, select your range and from the Data tab, click Remove Duplicates. A popup will allow you to select which fields to select for your duplicate values. You can unselect all fields, and selecting just a couple of fields will break down your list more than if you have many fields included. Be careful, as this will delete your data, so you may want to save the results with the different name using “Save As” (you can also click “undo” if the list does not look correct or not save your file at all).


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>