Have you ever found yourself with an Excel database which has duplicate data and you have had to go through the entire database cell by cell to try and get rid of the duplicated data. Well here is an Excel Tip to help you out in the future to remove this duplicate data quickly and easily.

Follow these steps to remove your duplicate data:

Click on any cell in the database and then go to the ribbon at the top and select the Data tab.

Select the remove duplicates options which will in turn select the entire database and bring up the Remove Duplicates dialog box.

You will also see in this dialog box that all of the column headings are selected. From here you have two choices to choose from. You can either:

Remove only the records that match another record exactly in the database or Remove records which have duplicate data in only one or more columns.

To remove the records which match another exactly, leave all the column headings selected and then click ok.

If you just want to remove the records that have duplicate data in one or more columns, remove the check marks from the columns which you don’t want to include in your comparison and then click ok.

Remember: if something goes wrong, use Ctrl+Z on the keyboard to undo your actions.

Are you interested in more Excel Tips? Then visit our Microsoft Excel Tips Page

Want to learn more about Excel? Then book yourself on one of our Microsoft Excel Training Courses.