How to Highlight and Remove Duplicates in Google Sheets

When working with Google Sheets you can come across some large spreadsheets where you have to…