Remove duplicates

You can use this option to remove duplicates from your database.  It allows you to pick which columns it must look for duplicates in.  Just beware – before using this option make sure you have a backup.  Once it has deleted the duplicates, you cannot retrieve them.  (Tip: you can use the Conditional Formatting option to highlight duplicates and then manual check them and delete.  See later.)