Removing duplicates in a Excel spreadsheet

 Excel functions are used to 

The following function i personally use on a regular basis and will help you save time on work:

Removing Duplicate values

First you will set up the spreadsheet by highlighting all columns in your table by clicking Ctrl + A on your keyboard. 

Next, you will click "Data" from the toolbar then "remove duplicates". A window will appear and you will uncheck every column except for the one with the values that should be unique.

Finally, click OK and Excel will notify you of how many duplicates were removed.